Exam 17: Database Design Using the Rea Data Model

E-R diagrams can be used to represent the contents of any kind of database.

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.A well-designed REA diagram would

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.

An REA diagram must link every event to at least one ________ and two ________.

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

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

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

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?

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

Every person in the world has a birthdate,but no person has more than one birthdate.Thus,the cardinality that exists between birthdate and people is

________ consists of translating the internal-level schema into the actual database structures that will be Implemented in the new system.

Identify the notation below that is not used to represent cardinality information.

Describe the steps in developing an REA diagram.

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.A well-designed REA diagram would

Define cardinality.

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

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

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