Exam 2: The Relational Model

Every cell in a relation can hold only a single value.

While the relational model for databases appears to hold much promise,few commercial databases have implemented it.

Although Microsoft Access is a personal database,the database tables in Access are still subject to ________ if they are not well-formed.

What is a multivalued dependency,and how do they affect the normalization process?

Any table that meets the definition of a relation is said to be in second normal form.

Since surrogate keys are used to uniquely identify rows,their values are normally displayed prominently on all forms and reports for the users to see.

The use of surrogate keys usually complicates application programming since most DBMS products require the application program to generate surrogate key values.

Explain the concept of a functional dependency.

In Microsoft Access,relationships between tables are built in the ________.

To represent a relationship in the relational model,the primary key of one relation is placed into a second relation.

In the normalization process,it is necessary to identify all the determinants in a relation.

To be considered a composite key,a key must contain at least two attributes.

To be a well-formed relation,every ________ in the relation must be a candidate key.

Given the functional dependency for the attributes of ENTITY1,X → (A,B, C), X is a candidate key for the relation ENTITY1 (A, B, C, X).

The key that has been designated the ________ key of a relation functionally determines all the other attributes in the relation.

Microsoft Access forms can only contain data from one table.

A(n)________ is one or more columns of a relation that is used to identify a row.

In Microsoft Access,referential integrity constraints are created ________.

To create a relationship in Microsoft Access,we drag and drop the ________ of a table.

In the normalization process,if you find that every determinant in a relation is a candidate key then you have determined that ________.