FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: The Relational Model and Normalization

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

A functional dependency is a relationship between attributes such that if we know the value of one attribute,we can determine the value of the other attribute.

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

A referential integrity constraint limits the values of a foreign key.

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

A table that meets the definition of a relation is in ________.

In general,each relation should have ________.

Any table that meets the definition of a relation is said to be in first normal form (1NF).

A constraint that requires an instance of an entity to exist in one relation before it can be referenced in another relation is called an insertion anomaly.

A surrogate key is an artificial column that is added to a relation to be its primary key.

A key is a combination of one or more columns that is used to identify particular rows in a relation.

Relations are classified into normal forms based on the types of modification anomalies that they are vulnerable to.

An attribute is considered to be a non-key attribute when it is a non-prime attribute,which means that the attribute is not contained in any candidate key.

Surrogate keys usually slow performance.

A deletion anomaly exists when deleting data about one entity results in the loss of data about another entity.

A relation is also known as a(n) ________.

If a table meets the minimum definition of a relation,it has an effective or appropriate structure.

A referential integrity constraint is used to make sure the values of a foreign key match a valid value of a primary key.

A combination of one or more columns used to identify particular rows in a relation is a ________.

A multivalued dependency exists when a determinant is matched to a set of values.

A relation is a table that has special restrictions on it.

The only reason(s) for having relations is to ________.

A relation is in 2NF if and only if it is in 1NF and all non-key attributes are determined by the entire primary key.