Exam 18: Implementing an Rea Model in a Relational Database

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

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.

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

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

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?

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.

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

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

In a relational database designed according to the REA model,where is information about transactions stored?

Explain a completeness check.

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

Nonfinancial information should be collected because

Concatenated keys are

Which of the statements below is false with respect to enterprise-wide REA diagrams?

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

Integrating separate REA diagrams into a single comprehensive enterprise-wide model of the organization requires understanding what the ________ in each separate diagram reveal about the organization's business policies and activities.

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

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?

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

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