Data Base
| 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,
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,