Introduction

Founded in 2010, CSC353 Air is the largest airline company of UW 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.

Air has several branches in different countries. Most branches are in UW on many states. Its dedicated employees are keen to prove the quality service often recommended by its customers. CSC353 Air is well known for low airfare for both way routes services across domestic customers. Highly dedicated in customer services, CSC353 Air offers several discount schemes for children and people with disabilities. CSC353 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, CSC353 Air is having more transactions, cUWsing day to day expanding business activities hard to manage its operations. To ensure more flexible service for customers, its 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 CSC353 Airline 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, and 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.

(Only do the question 3)