Exam 18: Implementing an Rea Model in a Relational Database
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?
C
What are the advantages of the REA data model over the traditional AIS model?
A major advantage of the REA data model is that it integrates non-financial and financial data in the AIS and makes both types of data easily accessible to management.In contrast to the REA data model,the general ledger in traditionally designed AISs uses the chart of accounts to store and organize data based on the structure of financial statements.Consequently,traditional AISs contain only data about the financial aspects of transactions.Other information that may be of use to management,such as the time of day a sale occurred or the reason why a customer was purchasing a specific item,would have to be stored in a separate database or information system.The existence of separate systems makes it more difficult for management to easily and quickly access the information it needs.It also provides opportunities for data entry errors to create inconsistencies between systems,thereby reducing the utility of any reports that are generated.Thus,a major benefit of using the REA model as the basis for designing an AIS is the ability to easily integrate information that traditionally appears in financial statements with other,non-financial information necessary to effectively manage operations and evaluate performance.It is vitally important that an organization's AIS be capable of storing both traditional financial measures and other operational performance measures.
When assigning attributes to each table,
D
Which of the following elements found in a traditional AIS system are not represented as entities in an REA relational database,but rather must be retrieved through the use of queries?
In a relational database designed according to the REA model,where is information about accounts receivable stored?
An integrated REA diagram merges multiple copies of ________ and ________ entities but retains multiple copies of ________ entities.
In a relational database designed according to the REA model,where is information about transactions stored?
From the choices below,identify the attribute below that would make the best primary key.
Which of the statements below is false with regards to the tables for M:N relationships?
Which of the following is/are true with regards to using REA diagrams to retrieve information from a database?
Identify the attribute below that would not make a good primary key.
When integrating multiple REA diagrams into an integrated REA diagram,to merge an event that appears in both business cycle REA diagrams,
In which of the following cases is the relationship between entities not implemented by foreign keys?
In a relational database designed according to the REA model,where is information about an organization's liabilities generally stored?
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.
Describe the steps that should be taken as a final accuracy check for designing a well-structured relational database.
Explain where in the REA model you can find the information normally found in a ledger.
When using an REA diagram to develop a database,a many-to-many relationship must be
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)