1. Which of the following pairs of entities would typically be associated with each other in stockflow relationship in a REA model?

1. Vendor and inventory
2. Purchase and inventory
3. Inventory and cash
4. Purchase & cash disbursement
5. Purchase & purchasing agent

2. The casual relationship between a give event and a take event is a ______ and ______ is defined as the inflow or outflow of a resource:

1. Duality relationship; stockflow
2. Conversion relationship; timing
3. Stockflow relationship; duality
4. Value chain relationship; resource flow
5. Difference relationship; process

3. Normalization is:

1. The process of following the guidelines for establishing the differential integrity rule.
2. The process of following the guidelines for properly designing a relation database that is free from, delete, insert, and update anomalies.
3. The process of following the guidelines for comforting and REA model into a relational database.
4. Both A & B
5. Both B & C

4. 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

5. 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)

Answer rating: 100% (QA)

The correct option is Purchase and Inventory Explanation A stockflow models an association between e... View the full answer