Question

ERD Diagram Exercises

Question 1

Create a Crow’s Foot ERD for each of the following descriptions. (Note that the word "many" is meant to mean "more than one" in a database modelling environment.)

a) Each of the MegaCo Corporation’s divisions is composed of many departments. Each of the departments has many employees assigned to it, but each employee works for only one department. Each department must be managed by one employee, and each of these managers can manage only one department at a time.

b) During some period of time, a customer can rent many videotapes from the BigVid store. Each of the BigVid’s videotapes can be rented to many customers during that period of time.

c) An airline can be assigned to fly one or more flights, but each flight is flown by only one airline.

d) The KwikTite Corporation operates many factories. Each factory is located in a region. Each region can be "home" more than one KwikTite’s factories. Each factory employs many employees, but each of these employees is employed by only one factory.

e) An employee may have earned one or more degrees, and each degree is earned by many employees.

Answer 1

Answer:

c an airline can be assigned to fly one or more flights