Question
Create a Crows Foot ERD for each of the following descriptions. (Note that the word many merely means more than one in the database modeling
Create a Crows Foot ERD for each of the following descriptions. (Note that the word many merely means more than one in the database modeling environment.)
a. Each of the MegaCo Corporations divisions is composed of many departments. Each department 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 download many ebooks from BooksOnline. Each of the ebooks can be downloaded by 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, and each region can be home to many of KwikTites factories. Each factory has many employees, but each employee 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
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started