Data Management and Security

Description

Summarised lecture notes for CSIT115 Data Management and Security over 12 weeks for students to easily understand the subject's theory with relevant examples. Topics include: - Introduction - Database Design - Object Data Model - Conceptual Modelling - Relational Data Model - Logical Design - Database Design Quality - Structured Query Language (SQL) - Data Definition Language (DDL) - Data Manipulation Language (DML) - Select Statement [1] - Select Statement [2] - Select Statement [3] - Select Statement [4] - Select Statement [5] - Views - Advanced DDL & DML Statements - Architecture of Relational Database Server - Database Security - Discretionary Access Control - User Management - Data Integrity - Data Vulnerabilities - Database Auditing - Data Privacy - Legal and Ethical Issues in Data Management