Ask Question
Computers and TechnologyComputers and Technology
4 March, 01:41

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.

+1
Answers (1)
  1. 4 March, 03:37
    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 and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers
You Might be Interested in
Describe how an attacker can use whois databases and the nslookup tool to perform reconnaissance on an institution before launching an attack. Discuss why whois databases should be publicly available.]
Answers (1)
What is the purpose of the overload keyword in the ip nat inside source list 1 pool nat_pool overload command?
Answers (1)
What was the first intel processor introduced in 1970 called
Answers (1)
Carol wants to decrease the voltage of the generated power so that she can safely use it. Which device should she use? A. Motor B. Generator C. Step-up transformer D. Step-down transformer
Answers (2)
What are the benefits of using a master document in Word 2016? Check all that apply. allows access to single documents from one central location reduces overall file size because a master document does not include subdocuments makes it convenient to
Answers (2)
New Questions in Computers and Technology
As they relate to databases, which of the following describes forms? A. Forms are a type of input used to generate reports. B. Forms are a type of output used to display data generated from queries. C.
Answers (1)
What is needed to create a good problem statement?
Answers (1)
Both of the following for clauses would generate the same number of loop iterations. for num in range (4): for num in range (1, 5) :
Answers (1)
At a minimum, you should always have these two versions of a résumé saved: a. Print and Web b. Web and Electronic c. Scannable and Print d. Electronic and Scannable
Answers (1)
One skill that's generally expected of technology workers is A. programming. B. keyboarding. C. Internet surfing. D. troubleshooting.
Answers (2)
Home » Computers and Technology » 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.
Sign Up Forgot Password?