CITS1402 summary (Semester 2, 2021)

Description

Hi everyone! This is a concise summary of the lectures and most tutorials covered in Semester 2, 2021, from week 1 to week 12. Please be aware that SQLite was used instead of MySQL in Semester 2 of 2021. This note will go over the following topics: - Relational model - DDL (Data Definition Language) and DML (Data Manipulation Language) - SELECT statement and its features - Aggregate function - DBMS features - Functional dependencies - Normal forms - Data integrity (how to enforce integrity and prevent integrity violation) - Relational algebra - ERD (Entity Relationship Diagram) - Subqueries - Views and Triggers - Index - CAST and substring examples - Document database (MongoDB) and relational database (SQL)