Exam 17: Database Design Using the Rea Data Model

Helge Autoparts sells new and refurbished auto parts exclusively to auto dealers.Helge purchases inventory from distributors at trade conventions.Each time Helge makes a purchase,the company records the suppliers name,address,date,specific items purchased,price paid for each,and the total amount spent.Helge later researches the inventory items to set the customer price.The company assigns an inventory number to each item purchased and records the customer price for each item.Helge buys price tags and display supplies from Alwin Incorporated,a company that sells them at all trade conventions.All inventory and supplies purchases are immediately paid for with cash or with checks from a bank account in Helge's name.All cash received from sales are also deposited to the same bank account.Several times a year Helge rents display space at dealer conventions.A deposit is always required,and the entire fee is due the day the convention starts.Helge records the deposit and final payment,along with the convention's name and address,in the same worksheet on which purchases of inventory and supplies are recorded. Consider Helge's processes regarding the purchasing inventory and supplies,renting display space,and paying for purchased items.In a well-designed REA diagram,what entities would reflect economic duality?

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

Identify the most likely relationship where cardinalities have zero minimums and N maximums.

A(n)________ diagram graphically depicts a database's contents by showing entities and relationships.

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

Prescott Dolls sells porcelain dolls exclusively at antique shows.Prescott Dolls purchases inventory from individuals at garage sales,flea markets,antique malls,and estate sales.Each time Dahlia Prescott (the owner)makes a purchase,she records the person's name,address,date,specific items purchased and price paid,and total amount spent.Later at home,Dahlia cleans,researches and prices the inventory for sale to customers.She assigns an inventory number to each item and records the "asking" price.Dahlia buys price tags and display supplies from a company that sells at flea market and antique shows.All inventory and supplies purchases are immediately paid for using cash or with company checks from a bank account in Prescott Doll's name.Cash received from customer sales are also deposited in this account.Three times a year,Dahlia rents a booth at antique shows.A deposit is always required,with the balance due at the start of the show.Dahlia 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. Draw an REA diagram for Prescott Dolls,related to purchasing inventory and supplies,renting booths,and paying for all items.

The maximum cardinality of any REA diagram relationship is

Define cardinality.

Which of the following statements about REA modeling and REA diagrams is false?

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

It is industry standard to model relationships as ________ in entity-relationship diagrams.

With regards to the database design process,accountants may provide the greatest value to their organization by participating in

Explain how an AIS system can be viewed as a set of "give-to-get" exchanges.

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

Identify the statement below that is false with respect to cardinalities.

Every person in the world can have more than one friend,and each person in the world can be a friend to more than one person.Thus,the cardinality that exists between friends and people is

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

REA models are usually depicted in which diagramming form?

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

Define minimum and maximum cardinalities.