1. An "Inventory Type" entity has the following attributes: part name, supplier number, part number, purchase date, quantity on hand, and cost. Which attribute represents a foreign key for the Inventory Type entity?

A. Cost

B. Quantity on hand

C. Supplier number

D. Part number

E. Purchase date

2.In order to view the record values in a Microsoft Access table use:

A. Design view

B. Database view

C. Datasheet view

D. Default view

3.When creating a table in Microsoft Access, which of the following fields should ALWAYS be specified as a Number field (and should thus NEVER be specified as either a Date , Currency , or Text field)?

A. Quantity sold

B. Customer number

C. Social security number

D. Invoice number

E. Total sales dollar amount

4.The purpose of foreign keys is to:

A. Uniquely and universally identify instances of the entity into which they are posted.

B. Link relations so the database can be used to store business data and to generate useful information.

C. Create null values in the database.

D. Determine minimum cardinalities of relationships between entities.

E. Determine maximum cardinalities of relationships between entities.

5.Entity integrity says that the value of a primary key must NOT contain a:

A. numeric value

B. null value

C. unique value

D. related value

6.Each column of a relational table represents a(n):

A. Relation

B. Record

C. Attribute

D. Cardinality

7.The objects on which business process model views are typically most often integrated are:

A. Resources

B. EventsAgents

C. Duality relationships

D. Date constraints

8.If two classes are related with a multiplicities 1..1 1..* how many tables must you include in a correctly designed database to represent these classes and association?

A. One

B. Two

C. Three

D. Four