Asked by Lamar
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
There are no human answers yet.
There are no AI answers yet. The ability to request AI answers is coming soon!
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.