Exam 18: Implementing an Rea Model in a Relational Database

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 "Employee" where it keeps information about its hair stylists.Identify the attribute below that most likely does not belong in the Employee table.

Explain the five rules for drawing integrated REA diagrams.

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.

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

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

In which of the following cases is the number of tables required to represent the relationship equal to three?

Rebus Fashions provides haircuts to men and women.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.

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

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 Purchases table?

Which of the statements below is false with regards to generating financial statements from an REA-based relational database?

Which entity is most likely to be part of both the revenue cycle and the expenditure cycle?

The major benefits of using the REA model as the basis for designing an AIS include all of the following except

Which of the statements below is false with regards to creating database tables from an REA diagram?

Which of the following would be true when implementing this REA diagram into a relational database?

In an integrated REA diagram,every resource must be must be linked to

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

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

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

Integrating separate REA diagrams developed for individual transaction cycles into a single,comprehensive enterprise-wide data model

In an REA diagram,resource entities