Problems:
Q 1)
Consider the following requirements for an airline tickets booking system. The system is composed of many airlines. Each airline is identified by a code, name and head quarter’s address. An airline has different mile programs, identified by a type- code, description, and starting date. The different types of flights offered by an airline have a unique number, day of the week, departure time, arrival time, origin, destination, and stops (if applicable). Passengers are allocated into flights and are identified by a number, name, address, sex and age. A passenger can subscribe for one mile program of a certain airline. The system records information about the passengers booked in a flight, together with the date, seat, pilot-name, and crewmembers of that flight. The system also maintains information about the miles accumulated by each passenger in a certain flight. This information is kept as a mile-order identified by a number, quantity and date. The booking can be done through a travel agency, identified by a code, name, address, contact person, and phone number. For each passenger in a flight a menu is served. The different menu options have a code and a respective description. The menu can be of type vegetarian, low fat, and kosher. For each vegetarian and low fat menu, information about the protein level and Kcal, respectively, of the meal is recorded. Each kosher meal has to be approved by the kosher community.
a. Draw the ER diagram above scenario by illustrating the attributes of the entities and relationships. Marks 10
b. Draw a star schema for the above ER diagram scenario and mention all facts necessary to calculate for the analysis of the company. Marks 10
Q 2) Explain Surrogate Keys in brief. Marks 10
Solution:
Related Posts
- Summer2007_CS614_02
- Summer2007_CS614_01
- Spring2007_CS614_05
- Spring2007_CS614_04
- Spring2007_CS614_03
- Spring2007_CS614_02
- Spring2007_CS614_01
- Special2006_CS614_05
- Special2006_CS614_04
- Special2006_CS614_03
