Exam 9: Designing Databases

________ is an integrity constraint specifying that the value (or existence)of an attribute in one relation depends on the value (or existence)of the same attribute in another relation.

A relation is said to be in second normal form when there are no transitive dependencies.

A transitive dependency is an integrity constraint specifying that the value of an attribute in one relation depends on the value of the same attribute in another relation.

Which of the following statements is true regarding normalization?

A single name that is used for two or more different attributes best defines:

The most common style for a logical database model is the:

A many-to-many relationship that associates certain items with their component items is called a:

Relationships between instances of a single entity type are referred to as:

The primary deliverable from logical database design is:

If for every valid value of A the value of B is determined by the value of A,then B is functionally dependent on A.

The selection of the appropriate storage format for each attribute from the logical database model is made during physical database design.

The selection of data storage technologies is made during the systems implementation and operation phase.

An ________ is a table used to determine the location of rows in a file that satisfy some condition.

For a binary one-to-one relationship between two entities A and B,the relationship is represented by:

Each regular entity type in an E-R diagram is transformed into a:

For a unary M:N relationship:

Generally speaking,a physical table corresponds to a relation.

________ is the process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields.

Object-oriented database models are the most frequently used database technologies for new information systems development.

Which of the following is not a key step in logical database modeling and design?