Exam 17: The Rea Data Model

Cosgrove Art & Antiques sells unique art and antiques exclusively at antique shows.Cosgrove purchases inventory from individuals and other dealers at garage sales,flea markets,antique malls,and estate sales.Each time Cosgrove makes a purchase,she records the person's name,address,date,specific items purchased and price paid,and total amount spent.Later at home,Cosgrove cleans,researches and prices the inventory items.She assigns an inventory number to each item and records the "asking" price.Cosgrove buys price tags and display supplies from a company that sells at flea market and antique shows.All inventory and supplies purchases are paid immediately with cash,or with checks from a bank account in the business' name,to which sales are also deposited.Several times a year Cosgrove rents a booth at an antique show.A deposit is always required,with the balance due at the start of the show.Cosgrove records the deposit and final payment,along with the show organizer's name and address,in the same worksheet on which purchases of inventory and supplies are recorded. A well-planned and correctly drawn REA diagram for Cosgrove Art & Antiques,related to purchasing inventory and supplies,renting booths,and paying for all items,would

Which of the following transactions is represented by the diagram below?

The REA data model

Which of the following is false about cardinalities?

Describe the possible relationships between entities,in terms of cardinalities.

Which of the following is not one of the rules in creating an REA data model?

Which of the following transactions is represented by the diagram below?

The maximum cardinality of a relationship in an REA diagram can be either

Describe the steps in developing an REA diagram.

Which of the following graphical symbols represents a minimum cardinality of one and a maximum cardinality of one?

How many types of relationships are possible between entities?

Which of the following transactions is represented by the diagram below?

Which of the following transactions is represented by the diagram below?

Define minimum and maximum cardinalities.

The process of defining a database so that it faithfully represents all aspects of the organization including its interactions with the external environment is called

Which of the following statements is true about the development of an REA model?

Which of the following transactions is represented by the diagram below?

Data modeling is an element of

Cosgrove Art & Antiques sells unique art and antiques exclusively at antique shows.Cosgrove purchases inventory from individuals and other dealers at garage sales,flea markets,antique malls,and estate sales.Each time Cosgrove makes a purchase,she records the person's name,address,date,specific items purchased and price paid,and total amount spent.Later at home,Cosgrove cleans,researches and prices the inventory items.She assigns an inventory number to each item and records the "asking" price.Cosgrove buys price tags and display supplies from a company that sells at flea market and antique shows.All inventory and supplies purchases are paid immediately with cash,or with checks from a bank account in the business' name,to which sales are also deposited.Several times a year Cosgrove rents a booth at an antique show.A deposit is always required,with the balance due at the start of the show.Cosgrove records the deposit and final payment,along with the show organizer's name and address,in the same worksheet on which purchases of inventory and supplies are recorded. A well-planned and correctly drawn REA diagram for Cosgrove Art & Antiques,related to purchasing inventory and supplies,renting booths,and paying for all items,would

Which of the following transactions is represented by the diagram below?