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.

Answer 1

Answer:

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