Exercise 8 FACTORIES The KwikTite Corporation operates many factories Each

Exercise 8 factories the kwiktite corporation

This preview shows page 3 - 5 out of 5 pages.

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.
Background image
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.
Background image
Image of page 5

You've reached the end of your free preview.

Want to read all 5 pages?

  • Fall '14
  • Relational Database, Reorder level, Entity-relationship model, Stock Control, preferred supplier, new entity types

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes