Ask Question

Use the following business rules to assign name to the tables on the ERD: Note: These rules are in the context of a small retail store and their charge account process. The case contains simplifying assumptions that may not accurately represent a real - world example. 1) A customer may be responsible for one account. 2) An account can have several charges posted to it but a charge may only be posted to a single account. 3) A charge may include an item and an item may be included on many charges. 4) An account may have several payments made against it but a payment may only be credited to a single account. Write the business rules for the following ERD shown in the figure below. The diagram represents the "Charge Account" at a small retail store. The ERD may contain simplifying assumptions that may not accurately represent a real-world example.

+5
Answers (1)
  1. 28 November, 02:20
    0
    Based on the business rules written in the question, following relationships could be made in the ERD,

    1. 1-1 relationship between Customer and Account tables.

    2. 1-many relationship between Account and Charge tables.

    3. 1-many relationship between Charge and Item tables.

    4. 1-many relationship between Account and Payment tables.

    Table names

    1. Customer

    2. Account

    3. Charge

    4. Payment

    5. Item
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Use the following business rules to assign name to the tables on the ERD: Note: These rules are in the context of a small retail store and ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers