Question
Given the following complicated business rules, create the appropriate Crow’s Foot ERD. (50 points)
a. A store may place many orders. (Note the use of “may”)
b. An order must be placed by a store.
c. An order contains at least one order line.
d. Each order line is contained in one and only one order.
e. Each order line has a specific product written in it.
f. A product may be written in many orders.
g. A store may employ many employees.
h. Each employee is employed by one (and only one) store.
i. An employee may have one or more dependents.
j. A dependent must be related to an employee.
a. A store may place many orders. (Note the use of “may”)
b. An order must be placed by a store.
c. An order contains at least one order line.
d. Each order line is contained in one and only one order.
e. Each order line has a specific product written in it.
f. A product may be written in many orders.
g. A store may employ many employees.
h. Each employee is employed by one (and only one) store.
i. An employee may have one or more dependents.
j. A dependent must be related to an employee.
Answers
Related Questions
2. Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy...
Using the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic, using th...
Problem #2 from page 173
Given the following business scenario, create a Crow’s Foot ERD using a sp...