Database Design for Flare Company - Database Normalization and Queries

This assignment presents a comprehensive database design for the Flare Company, addressing key aspects such as business rules, data architecture, and normalization. The solution outlines the importance of aligning business needs with software systems, emphasizing the use of business rules management and specification. The assignment includes an entity-relationship (ER) diagram, detailing tables like ADMINISTRATOR, AIRCRAFT, BOOKING, CUSTOMER, FLIGHT, and ROUTE. It meticulously applies normalization principles up to the Third Normal Form (3NF) to eliminate data redundancy and ensure data integrity. The solution further provides a data dictionary with field descriptions, data types, and primary/foreign key designations for each table. Additionally, it features SQL queries for data manipulation, including INSERT, TRANSFORM, SELECT, and UPDATE statements. The assignment concludes with recommendations for the business and identifies primary and foreign keys within the database schema, offering a complete and practical database design solution. The document is contributed by a student to be published on the website Desklib. Desklib is a platform which provides all the necessary AI based study tools for students.