ERD and Relational Schema — Unit 2#
Unit 2 subject matter covered:
Analyse and structure data and data stores to reduce redundancy and ensure completeness, consistency and integrity for use and storage
Determine appropriate data types, constraints, and primary and foreign keys
Evaluate and modify a database structure to third normal form (3NF) [QCAA, 2017]