Introduction to database design

posted by .

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.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. systems analysis design

    Task: Draw an ERD that shows cardinality relationships among the entities. When you create your ERD, you'll need to consider the training courses, trainers, corporate clients, students, test results, class schedules, and probably a …
  2. Systems Analysis Design Repost

    Draw an ERD that shows cardinality relationships among the entities. When you create your ERD, you'll need to consider the training courses, trainers, corporate clients, students, test results, class schedules, and probably a few more. …
  3. Maths

    Bill Ding plans to build a new hardware store. He buys a rectangular lot that is 50 ft by 200 ft, the 50-foot dimension being along the street. The store is to have an area of 4000 square feet. Construction costs $100 per linear foot …
  4. database management

    2. Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. …
  5. DBM 381

    Create a detailed ERD using the Entities and Attributes document provided with the Service Request. Create a Microsoft® Access® database using the ERD created above. You do not need to include keys and relationships at this point. …
  6. Information Systems

    Problem #2 from page 173 Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient …
  7. Marketing

    I am writing a report for marketing and have to create a fictional business. My first business was a clothing store. I need an idea for another business. I was thinking maybe a candy store, or a water ice store. Are they considered …
  8. data

    Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. …
  9. FL

    • Loops • File processing • Previously mastered course topics Create an application allowing employees to take orders and then tally up the total costs from its customers. The coffee shop offers the following items on its menu: …
  10. Business Math

    Abigail sells rice to store. she has a total of 125 cavans that she plans to distribute to three stores. if she gives 1/5 of what she has to store A can she devide the remaining equally to store B and C?

More Similar Questions