Computer Science Homework Solutions
Problem
#174748

Business rule for ERD

Write the business rules reflected in attached ERD.  Please see the attached file.  I am suppose to write the business rules for this ERD.

Example 1: 1) EMPLOYEE can have Zero-To-Many DEPENDENT 2) A DEPENDENT has Exactly-One EMPLOYEE Example 2: 1) A Store may place multiple Orders 2) An Order_Line contains has exactly-One Order and Exactly-One Product

Attached file(s):
Attachments
rules.jpg  View File
Solution
What is this?
By OTA - Overall OTA Rating
Charlene Li, MIWP (IP) - 4.4/5
Purchase Cost Now
$2.19 CAD (was ~$7.98)
Included in Download
  • Plain text response
  • Attached file(s):
    • busRules.doc
    • image001.gif
    • image002.gif
    • image003.gif
    • image004.gif
    • image005.gif
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • SQL problem in attach doc - MS SQL SERVER 2003 Problem 1 Write SQL queries 1. Write a SQL query that joins Customer and Store table in the Kudler database and uses BETWEEN to restrict record selection (use Store Name to res ...
  • SQL COMMANDS - Use SQL, and the Premiere Products database (see Figure 1.2) to complete the following exercises. 4. For each order, list the order number, order date, part number, part description, and item cl ...
  • Oracle 10g - Figures 1-24 and 1-25 (attached) display the data and relationships within the Clearwater Traders database. Reference these figures when completing the following cases. 1. Based on the description ...
  • Please answer me for these questions in detail for each question. - Exercise 1 In the following exercises, you will use the data in the Premiere Products database (shown in the attachment). Explain how you would use SQL to obtain the desired results: 1.Craete th ...
  • SQL Commands - See attach file for charts and data. Use SQL, and the Premiere Products database (see Figure 1.2) to complete the following exercises. 1. For each order placed on October 20, 2003, list the ...
Browse