Each model is made up from many parts and each part may be used in the

Each model is made up from many parts and each part

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

a suffix (such as GL or XL which indicates the degree of luxury) and an engine size.Each model is made up from many parts and each part may be used in the manufacture ofmore than one model. Each part has a description and an id code. Each model of car isproduced at just one of the firm's factories, which are located in London, Birmingham,Bristol, Wolverhampton and Manchester - one in each city. A factory produces many modelsof car and many types of part although each type of part is produced at one factory only.A UNIVERSITYA university consists of several faculties. Within each faculty there are several departments.Each department may run a number of courses. All teaching staff is attached todepartments, each staff member belonging to a unique department. (Note: see how many
Image of page 2
meanings you can assign to this ambiguous sentence). Every course is composed of Draw an entity-relationship model for this example. Show both cardinalities and optionalties.
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