Exam 18: Implementing an Rea Model in a Relational Database

In a relational database,which of the following attributes would typically be included in the table that stores data about the Vendor entity?

When using an REA diagram to develop a database,a many-to-many relationship must be

Much of the information about an organization's assets that is traditionally recorded in ledgers is stored in ________ tables in an REA-based relational database.

Explain where in the REA model you can find the information normally found in a journal.

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

In a relational database,which of the following attributes would typically be represented by a foreign key in the table that stores data about a Receive Inventory entity?

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 a relational database,which of the following attributes would typically be represented by a foreign key in the table that stores data about a Disburse Cash entity?

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

Explain a completeness check.

Which of the following statements is not true with regards to a correctly drawn enterprise-wide REA diagram?

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

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.

When comparing REA diagrams used to design an AIS with a traditionally designed AIS,

What are the advantages of the REA data model over the traditional AIS model?

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

Combining REA diagrams for individual transaction cycles into a single,enterprise-wide model adds two more rules to the three basic principles for drawing REA diagrams.Which of the following is not one of those two new rules?

In a relational database designed according to the REA model,where is information about an organization's liabilities generally stored?

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

An integrated REA diagram could contain multiple copies of