Question: Create a Crows Foot ERD for each of the following descriptions. (Note: The word many merely means more than one in the database modeling environment.)
Create a Crow’s Foot ERD for each of the following descriptions. (Note: The word many merely means “more than one” in the database modeling environment.)
a. Each of the MegaCo Corporation’s divisions is composed of many departments. Each of those departments has many employees assigned to it, but each employee works for only one department. Each department is managed by one employee, and each of those 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 airliner can be assigned to fly many flights, but each flight is flown by only one airliner.
d. The 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 those employees is employed by only one factory.
e. An employee may have earned many degrees, and each degree may have been earned by many employees.
Step by Step Solution
3.44 Rating (170 Votes )
There are 3 Steps involved in it
a The Crows Foot ERD is shown in Figure P216a As you discuss the contents of Figure P216a note the 1... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
358-CS-DB (524).docx
120 KBs Word File
