Each member of staff has a unique number name telephone extension number and

Each member of staff has a unique number name

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

Members of staff can request the use of parking space. Each member of staff has aunique number, name, telephone extension number and vehicle license number.# Illustrate the ERD for this Country Bus Company.
Image of page 1
# Design an Entity-Relationship diagram for the mail order database. Consider a mail orderdatabase in which employees take orders for parts from customers. The data requirementsare summarized as follows: The mail order company has employees identified by a unique employee number,their first and last names, and a zip code where they are located. The customers of the company are identified by a unique customer number, theirfirst and last names, and a zip code where they are located. The parts being sold by the company are identified by a unique part number, a partname, their price, and quantity in stock.
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 3 pages?

  • Spring '14
  • JD.Starkey
  • Computer Graphics, Entity-relationship model, Parking lot, Parking space, IDEF1X, Data Requirements

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture