Exam 18: Implementing an Rea Model in a Relational Database

Rebus Fashions provides haircuts to men and women.Rebus charges $10 per haircut,no matter what type of haircut the customer selects.Rebus uses an REA database to record information that is important to the firm.Rebus has an M:N table named "Customer-Sale" where it keeps information about customer sales.Identify the attribute below that most likely does not belong in the Customer-Sale table.

What is the first step to implementing an REA diagram in a relational database?

When integrating multiple REA diagrams into an integrated REA diagram,to merge an event that appears in both business cycle REA diagrams,

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. Which of the following would not be an attribute in the Inventory table?

Which of the following is a redundant entity that would be merged when two cycles are combined?

Rebus Fashions provides haircuts to men and women.Rebus uses an REA database to record information that is important to the firm.Rebus has a table named "Customer" where it keeps information about its customers.Identify the attribute below that most likely does not belong in the Customer table.

Which of the following is not part of a "final accuracy check" when creating relational tables from an REA diagram?

From the choices below,identify the attribute below that would make the best primary key.

Which of the following is not one of the three steps to implementing an REA diagram in a relational database?

Which of the following is true with regards to REA diagrams and relational databases?

An integrated REA diagram merges multiple copies of ________ and ________ entities but retains multiple copies of ________ entities.

Why might the same REA diagram result in different relationship cardinalities?

An integrated REA diagram could contain multiple copies of

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. Which of the following would be an attribute in the table for Display Space Rental?

In an REA-based relational database,the information normally found in a ________ is contained in the tables used to record data about ________.

Information traditionally found in journals is stored where in an REA database?

A query that extracts,for a given time period,the total amount of all sales events for which there is no corresponding receive cash event will yield

Because information about temporal imbalances between two ________,such as accounts receivable and accounts payable,is needed so frequently,such calculated values are sometimes stored as ________ in the appropriate tables.

Which of the following is/are true with regards to using REA diagrams to retrieve information from a database?

How many tables are needed to implement an REA data model that has five distinct entities,five M:N relationships and three 1:N relationships in a relational database?