Exercise 8 - FACTORIESThe KwikTite Corporation operates many factories. Each factory is located in a region. Each region can be "home" to many of KwikTite’s factories. Each factory employs many employees, but each of these employees is employed by only one factory. Exercise 10 - AIRLINESFastFlight Airlines is a small air carrier operating in three north-eastern states. FastFlight is in theprocess of computerizing its passenger reservation system. The following data items have been identified: reservation code, flight number, flight date, origin, destination, departure time, arrival time, passenger name, seat number, reservation agent number and reservation agent name. For example, flight number 303, which is scheduled every Tuesday and Thursday, leaves Augusta, Maine, at 9:23am and arrives in Nashua, New Hampshire at 10:17am. You can assume that the Fast Freight reservation system will detect automatically whether empty seats are available. Draw the Entity Relationship Diagram for this system.
FLIGHTPASSENGERreserveRESERVATION AGENTFlight noorigindestinationDep-timeArr-timenameSeat noRes-codenumberAgent-nameFlight dateExercise 11 – DINNERSA cooking club organizes several dinners for its members. The purpose of the club is to allow several members to get together and prepare a dinner for the other members. The club president maintains a database that plans each meal and tracks which members attends each dinner, and also keeps track of which members creates each dinner.
- Fall '14
- Relational Database, Reorder level, Entity-relationship model, Stock Control, preferred supplier, new entity types