Conceptual and Logical Database Modeling for Blue Mountains College

This project presents a comprehensive database design for Blue Mountains College, encompassing both conceptual and logical models. The conceptual model identifies entities such as courses, students, lecturers, and classes, along with their relationships and cardinalities, visualized through an Entity Relationship Diagram (ERD). The logical model then details the attributes, data types, primary keys, and foreign keys for each entity, further illustrating the database structure with a logical ERD. The assignment covers supertype and subtype entities, inheritance, discriminators, and various relationships (one-to-many, many-to-many) between entities. It also provides a detailed explanation of the attributes, data types, and keys used in the database design. The database is designed to store information related to courses, students, staff, classes, units, buildings, rooms, student enrollment, and student scores. The solution provides a complete database design, including both conceptual and logical models with detailed ERDs and explanations.