AIS - Chapter 9

AIS - Chapter 9

11 cards   |   Total Attempts: 185
  

Cards In This Set

Front Back
Multiple-attribute primary keys
Concatenated Keys
Which of the following types of entities must become a separate table in a relational database?

a. resources
b. events
c. agents
d. all of the above
A. resources
b. events
c. agents
d. all of the above
How many tables are needed to implement an REA data model that has seven distinct entities, three M:N relationships, and five 1:N relationships in a relational database?

a. 7
b. 10
c. 12
d. 15
A. 7
b. 10
c. 12
d. 15
Which type of relationship cardinality must be implemented in a relational database as separate table?

a. 1:1 relationship
b. 1:N relationship
c. M:N relationship
d. all of the above
A. 1:1 relationship
b. 1:N relationship
c. M:N relationship
d. all of the above
Combining two REA diagrams typically does NOT involve merging which type of entity?

a. resources
b. events
c. agents
d. all of the above
A. resources
b. events
c. agents
d. all of the above
Which of the following elements of a traditional AIS can be derived from queries of an REA database?

a. journals
b. ledgers
c. claims (receivables and payables)
d. all of the above
A. journals
b. ledgers
c. claims (receivables and payables)
d. all of the above
Which of the following tables would most likely have a concatenated primary key?

a. Inventory
b. Sales
c. Inventory-Sales
d. none of the above
A. Inventory
b. Sales
c. Inventory-Sales
d. none of the above
An REA diagram contains four instances of the Employee entity. How many tables does this require in a relational database?

a. 1
b. 2
c. 3
d. 4
A. 1
b. 2
c. 3
d. 4
A business orders mass-produced merchandise frequently throughout the year. In which table should the attribute "quantity ordered" appear?

a. Order Inventory
b. Inventory
c. Order Inventory-Inventory
d. None of the above
A. Order Inventory
b. Inventory
c. Order Inventory-Inventory
d. None of the above
Which of the following statements is true only about an integrated REA data model?

a. Every event must be linked to at least two agents.
b. Every increment (Get) event must be linked to a decrement (give event.
c. Every resource must be linked to at least one increment event and at least one decrement event.
d. Every resource must be linked to at least one agent.
A. Every event must be linked to at least two agents.
b. Every increment (Get) event must be linked to a decrement (give event.
c. Every resource must be linked to at least one increment event and at least one decrement event.
d. Every resource must be linked to at least one agent.
In a relational database designed according to the REA model, information traditionally stored in ledgers can be obtained by querying which of the following?

a. resources
b. events
c. M:N relationship tables between resources and events
d. all of the above
A. resources
b. events
c. M:N relationship tables between resources and events
d. all of the above