Database Systems Assignment: Modeling, Normalization, and SQL

This document presents a comprehensive solution to a relational database systems assignment. Part A discusses the process of database modeling, including identifying entities, attributes, relationships, and creating an Entity-Relationship Diagram (ERD) using draw.io. Part B focuses on database normalization, demonstrating the transformation of relations into 3rd Normal Form (3NF). Part C provides SQL code, including CREATE TABLE statements, INSERT statements, SELECT queries, UPDATE statements, COMMIT, ROLLBACK, and various data manipulation commands. The assignment covers essential database concepts, providing a practical understanding of relational database design and implementation.