Homework Help: Introduction to database design

Posted by Lamar on Sunday, October 5, 2008 at 3:08pm.

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.

No one has answered this question yet.

Answer this Question

Related Questions

DBM 381 - Create a detailed ERD using the Entities and Attributes document ...
database management - 2. Given the following business scenario, create a Crow&#...
systems analysis design - Task: Draw an ERD that shows cardinality relationships...
Systems Analysis Design Repost - Draw an ERD that shows cardinality ...
Information Systems - Problem #2 from page 173 Given the following business ...
computer science - Using the Crow’s Foot notation, create an ERD that can ...
Business - 2. Assignment: Evolution of Business Presentation • Resources: ...
Maths - Bill Ding plans to build a new hardware store. He buys a rectangular lot...
databases - Fernando Cilebra has always ben facinated by skateboards. Fernando ...
relational database concepts - .Fernando Culebra, owner of Fernando's Skate...

For Further Reading

First Name:
School Subject:
Answer: