Database Management System Assignment 1 Report: ER Diagram & Schema

This report presents the solution to a Database Management System assignment (ITECH 1006). The report includes an Entity Relationship (ER) Diagram, assumptions made during the design, and the normalization process applied to the database tables. It details the relational schema, specifying table structures, field types, and primary/foreign key relationships for each table. The assignment covers key database concepts such as course types, staff, courses, classes, awards, members, and payment systems, demonstrating a comprehensive understanding of database design and implementation. References to the ER diagram symbols and representation are also included.