Data Base

Only available on StudyMode
  • Download(s) : 18
  • Published : January 2, 2013
Open Document
Text Preview
| 2010|
| ASSIGNMENTNooriya Zaheer
Lecturer: Mrs. Marwa FouadSubmission Date:16 March 2010|

[Relational Database systems (cS274)]|
The case study records information about scheduled and planned flights for an airline and the flight reservations made by customers. The key elements in the system revolve around Planned and Actual Flights, and the reservations made by customers of actual flights. |

Contents

Current Business Activities and Operations:3
List of Business Rules:4
Entities and Attributes:5
Relationship Types:6
Primary Keys:7
Foreign Keys:8
Normalization:9
Entity Relationship Diagram:10
Referencing:11

Current Business Activities and Operations:
Hotel reservation systems are used to track and maintain records of hotel schedules, visitor’s reservations and room assignments, check-in inventory, and fare tariffs. The modern hotel reservation system also serves customer needs from beginning to end of each visitor's reserved room or resort, therefore laying out management tasks for each flight. Today, Airways information is linked, stored, and retrieved by a network of computer reservations systems (CRS), accessible by multiple hotels and travel agents A Central Reservation System is a tool to reach the Global Distribution Systems as well as Internet Distribution Systems from one single system, namely a central reservation system. A CRS is mainly assistance for hoteliers to manage all of their online marketing and sales, where they can upload their rates & availabilities to be seen by all sales channels that are using a CRS. Sales Channels may include conventional travel agencies as well as online travel agencies. A hotelier using a central reservation system eases his/her tasks for online distribution, because a CRS does everything to distribute hotel information to the sales channels instead of the hotelier. . The global distribution system (GDS) makes for an even larger web of reservation information, not only merging the reservation of rooms and resorts for multiple airlines, but also making the systems accessible to consumers directly. GDS portals and gateways on the Web allow consumers to book hotels directly, select rooms, and even book rental cars.

List of Business Rules:
* Up to 90% of the hotels are available for reservations during peak and commute periods; minimum of 50% of the hotels available for reservations during off‐peak periods. * Reservations on commute period made available 4 weeks in advance, all other available up to 6 months in advance to provide extra incentives for customers with schedule flexibility to reserve non‐commute period staying. * Regular reservations (non‐priority access) will require pre‐payment of fare. * There will be no extra fee for reservations.

* There will be flexibility to change or cancel reservations at no charge, though cancelation fees might apply in some cases. * Customers would need to arrive between 3 to 4 weeks of reservations. During peak periods, a customer arriving late could lose their reservation and be directed to the queue.

Entities and Attributes:

Entities and Attributes| Shape| Shape in Diagram|
Entities: * Customer| | Customer
|
Attributes: * Customer ID * Customer Name * Customer Phone Number * Customer Nationality| | Nationality Customer Number
Customer ID
Customer Name
|
Entities: * Hotel| | Hotel
|
Attributes: * Hotel Name * Check-in Time * Check-Out Time * Hotel Location * Hotel Type| | Hotel Type Check-outl Time
Hotel Name
Check-in Time
Hotel Location
|
Entities: * Room| | Room
|
Attributes: * Room Number * Registration Number * Capacity| | Capacity Room number
Date of Booking
|
Entities: * Booking| | Booking
|
Attributes: * Booking no * Number of Visitors * Date/Time| | Booking no. Number of Visitors
Date/Time
|
Entities: * Staff| | Staff
|
Attributes: *...
tracking img