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 31

Multiple Choice

Review LaterAdd Note

Review Later

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

A) record
B) field
C) composite key
D) foreign key
E) surrogate key

Correct Answer

verified

Show Answer

Question 32

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 33

True/False

Review LaterAdd Note

A key can be composed of a group of attributes taken together.

A relation is in 4NF if it is in BCNF and it has no multivalued dependencies.

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

A relation that is in domain/key normal form is assured to be free from all anomalies.

Undesirable consequences of changing the data in a relation are called "modification anomalies."

Given the functional dependency (A,B)→ C,the attributes (A,B)are referred to as a composite determinant.

In functional dependencies,the attribute whose value is known or given is referred to as the determinant.

Given the functional dependency (A,B)→ C,then it is true that A → C and B → C.

A relation is in 3NF if and only if it is in 2NF and there are no non-key attributes determined by another non-key attribute.

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

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

A ________ is used to limit the possible values of a(n) foreign key.

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.

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

Domain/key normal form requires that every constraint be a logical consequence of the definition of domains and keys.

A defining requirement for Boyce-Codd Normal Form (BCNF)is that every candidate key must be a determinant.

In relational terms as defined by E.F.Codd,a column is called an attribute.

A relation is in Boyce-Codd normal form (BCNF) if and only if it is in 3NF and ________.