Exam 4: Logical Database Design and the Relational Model

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

A relation in fifth normal form may not contain any anomalies.

List and explain 1^st, 2^nd, 3^rd, BCNF, 4^th, and 5^th normal forms.

When transforming a weak entity, one should create one relation with both the attributes of the strong entity and the attributes of the weak entity.

An anomaly is a type of flaw in the database server.

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

Discuss the various relational keys.

A foreign key is a primary key of a relation that also is a primary key in another relation.

Discuss the two major occasions when you benefit from using normalization.

A co-dependency is a constraint between two attributes or two sets of attributes.

A candidate key is an attribute, or combination of attributes, that uniquely identifies a row in a relation.

A primary key is an attribute that uniquely identifies each row in a relation.

In the figure below, what is depicted?

An attribute that may have more than one meaning 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:

A constraint between two attributes is called a(n):

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

A relation that contains minimal redundancy and allows easy use is considered to be:

Discuss the two possible scenarios when mapping an associative entity.

Data structures include data organized in the form of tables with rows and columns.