Task#1 [Marks: 5]:
Draw an Entity Relationship Diagram (ER Model) for the given case study along with proper associations and cardinalities.
Task#2 [Marks 5]:
Derive the tables from the ER model and normalize up to third normal form (3rd NF)
Task#3 [Marks 10]:
De-normalize the database (obtained after completing task#2) by using the “collapsing tables” technique.
CASE STUDY:
Section 1: Introduction
1.1 Vision Statement:
1.1.1 Software Purpose
The main purpose of this software is to reduce the manual errors involved in the airline reservation process and make it convenient for the airline staff to perform their daily reservation related tasks e.g. tickets reservation, flight scheduling, announcements etc. in automated way.
1.1.2 Software Scope
This software provides options for passengers to view and search different flights along with their timings and reservation details for a particular date.
For administrators (staff members), it will facilitate them to manage the route schedules (adding, editing, canceling and viewing routes), reservations (booking, modifying, canceling and viewing) and staff.
nnect to local airport services database system to get the current status of the runway and other notifications etc. The super admins will use this information to reserve the runway for them and to schedule their flights. Application will connect with this database system through provided interface.
The system also needs to connect to an international weather forecasting service to get weather forecasting details. This information will also be used for flight scheduling.
2.4 Assumptions and dependencies
It is assumed that passengers will first see the flight schedules and fare details from the passenger terminal computers (dedicated only for the passengers). After selecting a particular flight and seat, they will get print of it and will go to reservation booth, where sub admin staff member will reserve ticket for them by seeing the printed specification.
Also, any breaking news e.g. modification of flight timing etc. will be immediately added to the system by admins, and will immediately be visible through passenger interface.
