MyPoly Airlines Database: Database Design and SQL Implementation

This report presents a comprehensive database design for MyPoly Airlines, addressing the assignment brief's requirements for BIT231 Database Systems. It begins with an overview of the business rules governing the airline's operations, followed by detailed entity-relationship (ER) modeling. The ER model includes entities such as AIRPLANE, MAINTENANCE, FLIGHT, PILOT, and PASSENGER, along with their respective attributes and relationships. A data dictionary is provided, detailing each table's attributes, data types, and constraints. A dependency diagram illustrates the relationships between tables. Furthermore, the report includes SQL statements, specifically DDL (Data Definition Language) for table creation and DML (Data Manipulation Language) for data insertion, along with screenshots demonstrating the implementation. The report covers all aspects of the assignment, from ER modeling to SQL implementation, providing a complete database solution for MyPoly Airlines.