文档介绍：Unit 11
Case Study
pany Information System
11/10/2017
1
Unit 11
Step 1: Join data and functional analysis
Step 2: Analysis important operations
Step 3: High-level logical design
Step 4: Logical design for relational model
Outlines
11/10/2017
2
Unit 11
Step1:
Join data and functional analysis
Drawing the skeleton F-schema
Drawing the skeleton D-schema
Repeating the refinements of the D-schema and the F-schema to plete ones
11/10/2017
3
Unit 11
Requirements
pany is subdivided into two major areas: passenger management and service management. Passenger management deals with reservations of bus seats and with providing information to passengers and travel agencies about schedules and fares. Service management deals anizing ordinary trips, special trips, managing buses, and bus drivers.
11/10/2017
4
Unit 11
Seat reservations are made directly by passengers or by travel agencies; they can be made on any bus service (both ordinary and special) and are free. The passengers can ask for a smoking or nonsmoking area. Reservations can be made for segments of the bus trip; thus, the same seat might be made available to different persons on different parts of the same trip. The office holds the trip description sheets, which are prepared about four weeks before the actual beginning of the trip; they include the schedule of the trip, the list of all intermediate stops, and spaces for each seat, where it is possible to write reservations. Trip description sheets are prepared by the service management office and used by the reservation office to record the reservations. They are returned to the service management office at least 2 hours before departure; thus, reservations cannot be taken immediately before the departure.
The main office has a reservation desk and some dedicated telephone lines for reservations. Fare information is given at a different office, called the fares office, which also has dedicated telephone lines. Fares are reported in a fare descrip