Exam 4: Logical Database Design and the Relational Model

Two or more attributes having different names but the same meaning are called:

________ anomalies can be caused by editing data in tables.

View integration is the process of merging relations together.

When two or more attributes describe the same characteristic of an entity, they are synonyms.

A referential integrity constraint is a rule that maintains consistency among the rows of two relations.

The truncate table statement in SQL creates a new table.

A composite key consists of only one attribute.

In the figure below, Customer_ID in the CUSTOMER Table is which type of key?

The entity integrity rule states that a primary key attribute can 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.

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.

Discuss how you would map a regular entity to a relation.

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

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

Data is represented in the form of:

Explain what a candidate key is and how it might be used.

All values that appear in a column of a relation must be taken from the same domain.

A cascading delete removes all records in other tables associated with the record to be deleted.

Referring to the figure below, which of the following is NOT true?

One property of a relation is that each attribute within a relation has a unique name.