Database management system

Introduction Founded in 2010, BU Air is the largest airline company of BU with greater than 100,000 hours of flights, 3 million satisfied passengers from 9 different domestic destinations. It has the highest capacity aircraft, all equipped with modern technology stuffs ensuring quality & safe flying. BU Air has several branches in different countries. Most branches are in AU on many states. Its dedicated employees are keen to prove the quality service often recommended by its customers. BU Air is well known for low airfare for both way routes services acrosse domestic customers. Highly dedicated in customer services, BU Air offers several discount schemes for children and people with disabilities. BU Air has won multiple awards for its safety & reliability records of flying from national and international organizations. Due to its high reliability, safety records and highly gained trusts from customers, BU Air is having more transactions, causing day to day expanding business activities hard to manage its operations. To ensure more flexible service for customers, it's highly recommended to implement an Airlines Reservation System, a computerized system that will help manage all information related to the operation of the system. You have been asked to build the BU Air Reservation System. To start, do a more detailed analysis of the above system and provide the following: 1. In detail, Identify all the appropriate entities (with keys), attributes, relationships, ande constraints 2. Provide a complete ER diagram for the database (Use Visual Paradigm, or similar tool) 3. Make any assumptions that are relevant to the system. Clearly define your assumption. Submit your document to BU Blackboard as your FirstLastName.pdf. Introduction Founded in 2010, BU Air is the largest airline company of BU with greater than 100,000 hours of flights, 3 million satisfied passengers from 9 different domestic destinations. It has the highest capacity aircraft, all equipped with modern technology stuffs ensuring quality & safe flying. BU Air has several branches in different countries. Most branches are in AU on many states. Its dedicated employees are keen to prove the quality service often recommended by its customers. BU Air is well known for low airfare for both way routes services acrosse domestic customers. Highly dedicated in customer services, BU Air offers several discount schemes for children and people with disabilities. BU Air has won multiple awards for its safety & reliability records of flying from national and international organizations. Due to its high reliability, safety records and highly gained trusts from customers, BU Air is having more transactions, causing day to day expanding business activities hard to manage its operations. To ensure more flexible service for customers, it's highly recommended to implement an Airlines Reservation System, a computerized system that will help manage all information related to the operation of the system. You have been asked to build the BU Air Reservation System. To start, do a more detailed analysis of the above system and provide the following: 1. In detail, Identify all the appropriate entities (with keys), attributes, relationships, ande constraints 2. Provide a complete ER diagram for the database (Use Visual Paradigm, or similar tool) 3. Make any assumptions that are relevant to the system. Clearly define your assumption. Submit your document to BU Blackboard as your FirstLastName.pdf