Wednesday
April 1, 2015

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.

Answer this Question

First Name:
School Subject:
Answer:

Related Questions

database management - 2. Given the following business scenario, create a Crow’s ...
DBM 381 - Create a detailed ERD using the Entities and Attributes document ...
Information Systems - Problem #2 from page 173 Given the following business ...
systems analysis design - Task: Draw an ERD that shows cardinality relationships...
Systems Analysis Design Repost - Draw an ERD that shows cardinality ...
computer science - Using the Crow’s Foot notation, create an ERD that can be ...
Business - 2. Assignment: Evolution of Business Presentation • Resources: Ch. 2 ...
Health Information Technology - I need sample copies of the following - Face ...
IT - Can someone help me with this? Design an application or site that presents ...
Data Management Systems - A stationary business is interested in starting a Web ...

Members