Database Report: ER Modeling, Normalization for MPoly Airlines

This report provides a comprehensive analysis of a database system designed for MPoly Airlines. It begins by outlining the business rules and entities involved, including flights, airplanes, pilots, maintenance procedures, and passengers. The report then details the attributes of each entity, defining data types, formats, and key constraints. An ER diagram visually represents the relationships between entities. The data dictionary provides a structured overview of each table's attributes. The report then delves into normalization, presenting a dependency diagram and demonstrating the database's adherence to 3NF. Furthermore, it includes SQL code for table creation, primary and foreign key definitions, and demonstrates the use of the DEFAULT clause. The report concludes with sample INSERT statements and a bibliography of cited sources.