Exam 4: Logical Database Design and the Relational Model

A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a ________ dependency.

The relational data model does, at this time, directly support subtype/supertype relationships.

CASE tools can model more complex data relationships, such as ternary relationships.

Discuss why it is a good idea to create an instance of your relational schema with sample data.

An alternative name for an attribute is called a(n):

The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called:

Discuss how to map a unary many-to-many relationship.

The truncate table statement in SQL creates a new table.

An attribute that may have more than one meaning is called a(n):

Discuss why it is important to remove multivalued attributes from a relation.

A two-dimensional table of data sometimes is called a:

The ________ states that no primary key attribute may be null.

________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated.

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

In the relational data model, associations between tables are defined through the use of primary keys.

Discuss how to map a unary one-to-many relationship.

The entity integrity rule states that:

The need to ________ relations commonly occurs when different views need to be integrated.

A form of database specification which maps conceptual requirements is called:

Understanding the steps involved in transforming EER diagrams into relations is important because: