Exam 17: Database Design Using the Rea Data Model

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

Identify the minimum cardinality of any REA diagram relationship.

The "get" event represents an activity which

Identify the item below that would be classified as an event by the REA data model.

Which of the following statements is false regarding REA diagrams?

In which stage(s)of the database design process should accountants participate?

In creating an entity-relationship diagram,________ is anything about which an organization wants to collect and store information.

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

Describe an REA data model.

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

Data modeling is an element of

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

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

An entity-relationship diagram represents entities as ________ and the relationships between them as lines and ________.

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

Identify the item below that would be classified as an agent by the REA data model.

Each event in an REA model will in most cases have at least one ________ agent and one ________ agent involved with the event.

An entity-relationship diagram

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

How many types of relationships are possible between entities?