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)


UWA

Semester 2, 2021


5 pages

2,109 words

$19.00

4

Add to cart

Campus

UWA, Crawley

Member since

November 2021