1. Which of the following describes referential integrity?

1. A primary key of a relational table must not contain a null value
2. The value for a foreign key attribute must either be null or match one of the data values in the table in which the attributes is a primary key
3. One fact must not be in multiple places
4. Referential integrity is a principle that prevents the use if redundancy, avoids null values, and creates a minimal database
5. Multiple facts must not be stored in a single cell

2. Customers that come into Furniture Galore, Inc. may be helped by any available salesperson. If more than one salesperson helps the same customer with the same merchandise, any resulting sale to that customer will be credited to all involved salespeople, who will split the sale commission. Salespeople are added to the database as soon as they are hired. A sale cannot be made without a salesperson. The cardinalities for the relationship between Sale and Salesperson for Furniture Galore, Inc. are:

1. Sale (1, 1) to salesperson (0, 1)
2. Sale (1, 1) to salesperson (0, N)
3. Sale (0, N) to salesperson (1, 1)
4. Sale (0, N) to salesperson (1, N)
5. Sale (1, N) to salesperson (0, N)

3. When an event participated in a stock-flow relationship, which of the following is true?

1. The other participant in the relationship must be a focal event.
2. The other participant in the relationship must be a resource.
3. The other participant in the relationship must be an external agent.
4. The other participant in the relationship must be an internal gent.
5. The other participant in the relationship must be another event.

4. Which of the following is NOT an example of resource in the REA model?

1. Customer
2. Raw materials
3. Land
4. Cash
5. Finished goods

5. Each column of a relational table represents a (an):

1. Tuple
2. Relation
3. Record
4. Cardinality
5. Attribute

6. The purpose of foreign keys is to

1. Determine maximum cardinalities of relationship between entities
2. Uniquely and universally identify instances of the entity into which they are posted
3. Determine minimum cardinalities of relationships between entries
4. Create null values in the database
5. Link relations so the database can be used to store business data and to generate useful information

7. If you have a many to many relationships between inventory and sale, where in the database tables should you record the attribute quantity sold?

1. Anywhere in the sale table
2. Anywhere in the inventory table
3. After the inventory stock number which is posted into the sale table as a foreign key
4. After the invoice number which is posted into the inventory table as a foreign key
5. In a table represents the relationship between inventory and sale (i.e., the inventory-sale table

8. The resource that is most likely to be found in multiple business processes in all types of organizations is:

1. Employee
2. Cash
3. Cash disbursement
4. Inventory
5. sale

9. Which pair is most likely to be linked together in a financing cycle stockflow relationship?

1. Cash requestion and cash
2. Cash and cash disbursement
3. Acquisition and inventory
4. Dividend declaration and cash
5. Stock issuance and cash receipt

10. What claim accrues if a cash disbursement occurs without corresponding purchase that total the cash disbursement amount?

1. Accounts payable
2. Wages payable
3. Accounts receivable
4. Duality
5. Prepaid expense

11. the objects on which business process model views typically most often integrated are:

1. Duality relationship
2. Resources
3. Agents
4. Date constraints
5. Events

12. In the REA model, the act of a payroll clerk issuing payroll checks to employees to compensate them for hours worked is a:

1. Economic decrement event
2. Economic increment event
3. Instigation event
4. Commitment event
5. Economic reversal eventWhen creating a database in Microsoft access

1. Foreign keys must be specified for each table.
2. In access it is impossible to create a table without designing a primary key.
3. All data and three problems resulting error messages.
4. Referential integrity is only enforced for those relationships for which the database design or user places a check mark in a box for enforce referential integrity during or after creation of the relationship in the relationship layout.
5. To delete a relationship, simply deleting one of the tables involved in the relationship will do the trick.

13. In relational database design, a primary key of one table that is also included in another table

1. Usually ensure that we can get all the information we need to make a decision by querying only one table or the other (i.e., we would not need both tables in the same query).
2. Usually establishes a connection between the tables so they can be linked to generate useful information.
3. Usually results in null value being introduced into the database
4. Usually indicates that someone made a mistake in deriving the table and has added undesirable data redundancy into the database
5. Usually uniquely and universally identifies each instance in both tables in which it is included.

14. Which of the following is FALSE regarding use of relational tables?

1. The table in a relational database are linked to each other through primary and foreign keys.
2. All data values in a column must conform to the same data format.
3. Each cell in a relational table can contain only one value.
4. To build a query, you must know the order of all rows and columns in each relational table.
5. All of the above are TRUE (i.e., none of the above are false).

15. Which of the following financial statements balances is NOT affected by events that occurred on the expenditure cycle?

1. Supplies inventory
2. Cost of goods sold
3. Raw material inventory
4. cash
5. All of the above are affected by events that occurred in the expenditure cycle

16. Examine the entity pairs presented. Which pair is most likely to be linked together on a financing cycle duality relationship?

1. Loan agreement and cash receipt
2. Cash receipt and cash disbursements
3. Dividend declaration and stock issuance
4. Cash requisition and loan agreement
5. Sale and cash receipt

17. Goods or services that are outputs of the manufacturing (conversion) process in a companys value chain generally become inputs to the

1. Financing process
2. Expenditure process
3. Training process
4. Human resource process
5. Revenue process

18. Which of the following financial statement line items require queries that encompass duality relationship?

1. Net sales on income statement
2. Cost of goods sold on income statement
3. Inventory on a balance sheet
4. Accounts receivable on a balance sheet
5. Wages expenses on an income statement