ais ch 18 part 1

12) REA diagrams for different organizations may be similar, but will likely result in different relationship cardinalities because of A) differences in business policies. B) different designers of REA diagrams. C) different methods of drawing REA diagrams. D) errors in drawing REA diagrams.

A

2) The primary key for a Sales-Inventory table that consists of the Sales Invoice Number and the Inventory Item Number, is known as a A) concatenated key. B) condensed key. C) double key. D) dual key.

A

4) The type of relationship between two entities is determined by A) maximum cardinalities only. B) minimum cardinalities only. C) minimum and maximum cardinalities. D) median cardinalities.

A

5) Which of the following is not one of the steps in implementing an REA diagram in a relational database? A) implement many-to-many relationships with foreign keys B) create tables for entities C) assign attributes to tables and identify primary keys D) implement one-to-many relationships with foreign keys

A

6) An integrated REA diagram merges multiple copies of ________ and ________ entities but retains multiple copies of ________ entities. A) resource; event; agent B) event; agent; resource C) resource; agent; event D) None of the above. An integrated REA diagram merges multiple copies of all entities.

A

7) An integrated REA diagram could contain multiple copies of A) customers. B) sales. C) inventory. D) sales-inventory.

A

13) What is the first step to implementing an REA diagram in a relational database? A) Assign attributes to appropriate tables. B) Create a table for each distinct entity in the diagram and for each many-to-many relationship. C) Identify cardinalities. D) Use foreign keys to implement one-to-one and one-to-many relationships.

B

17) The primary key for M:N relationship tables A) is a single attribute. B) always consists of two attributes. C) is the primary key of the most important entity linked to that relationship. D) does not exist. Many-to-many relationship tables only use foreign keys.

B

8) An integrated REA diagram merges multiple copies of some entities in order to A) minimize the repetition of agent entities. B) maximize the legibility of the diagram by avoiding the need to have relationship lines cross one another.

B

10) Concerning a correctly drawn enterprise-wide REA diagram, which of the following statements is not true? A) Every event must be linked to at least one resource. B) Merging two transaction cycles on a common event may affect the minimum cardinalities between the merged event and the other events. C) Events can only be merged if they share the same resources and events. D) Creating a set of tables from an REA diagram automatically results in a well-structured relational database.

C

11) Which of the following is not one of the three steps to implementing an REA diagram in a relational database? A) Assign attributes to appropriate tables. B) Create a table for each distinct entity in the diagram and for each many-to-many relationship. C) Every event must be linked to at least one resource. D) Use foreign keys to implement one-to-one and one-to-many relationships.

C

15) Concerning the creation of tables from an REA diagram, which of the following is false? A) A properly designed relational database has a table for each distinct entity in an REA diagram. B) A properly designed relational database has a table for each many-to-many relationship in an REA diagram. C) To reduce confusion, table names should not duplicate REA diagram entities' names. D) Many-to-many relationships will be shown in tables with hyphenated concatenations of the entities' names.

C

18) Attributes other than the primary key are A) included to satisfy transaction processing requirements. B) included to meet management's information needs. C) both A and B D) none of the above

C

19) Concerning tables for M:N relationships, which of the following statements is false? A) Non-key attributes may be included. B) Multiple attribute primary keys are used. C) Single attribute primary keys may be used. D) Concatenated keys are used.

C

9) 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? A) Every resource must be linked to at least one event that increments that resource and to at least one event that decrements that resource. B) If a specific event can be linked to more than one other type of event, but cannot be linked simultaneously to all of those other events, then the minimum cardinality between that event and every other event with which it may be associated must be 0. C) If a specific event can be linked to more than one other type of event, but cannot be linked simultaneously to all of those other events, then the maximum cardinality between that event and every other event with which it may be associated must be 0. D) All of the above are new rules for drawing integrated REA diagrams.

C

1) Integrating separate REA diagrams developed for individual transaction cycles into a single, comprehensive enterprise-wide data model A) is possible. B) requires understanding what the cardinalities in each separate diagram reveal about the organization's business policies and activities. C) provides a single comprehensive enterprise-wide model of the organization. D) All of the above are true.

D

14) Concerning REA diagrams and relational databases, which of the following is true? A) A well-designed relational database is the starting point for creating an REA diagram. B) A well-designed REA diagram minimizes update, insert or delete anomaly problem when the diagram is implemented into a relational database. C) REA diagrams and database design are generic across organizations. D) The design of a relational database is specific to the organization being modeled.

D

16) When assigning attributes to each table, A) the database designer must interview users to identify which facts should be included in the database. B) the database designer must interview management to identify which facts should be included in the database. C) the database designer must use the REA diagram to help determine in which tables those facts belong. D) the database designer must do all of the above.

D

20) Nonfinancial information should be collected because A) it may indicate events that may affect resources. B) it can be used to plan other activities. C) it can be used in transaction processing. D) both A and B

D

3) When using an REA diagram to develop a database, many-to-many relationships must be A) broken into multiple one-to-one relationships. B) combined into a single one-to-one relationship. C) combined into a one-to-many relationship. D) broken into multiple one-to-many relationships.

D