Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions