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 51

True/False

Review LaterAdd Note

Review Later

All relations are tables,but not all tables are relations.

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

A relation is in fourth normal form if it is in BCNF and it has no ________.

A) transitive dependencies
B) multivalued dependencies
C) partial dependencies
D) deletion dependencies
E) referential integrity conflicts

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

Any table that meets the definition of a relation is in 2NF.

An attribute is also known as a ________.

Candidate keys are called interlocking candidate keys when they share one or more attributes.

A tuple is a group of one or more columns that uniquely identifies a row.

Functional dependencies can involve groups of attributes.

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

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

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

Referential integrity constraints are used to limit the possible values of a ________.

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

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.

The essence of normalization is taking a relation that is not in BCNF and breaking it into multiple relations such that each one is in BCNF.

Given the functional dependency A → (B,C) ,A is a(n) ________.

The condition that a non-key attribute determines another non-key attribute is know as transitive dependency.

In a relation ________.

In the functional dependency shown as A → B,B is the determinant.

Attribute Y is functionally dependent on attribute X if the value of attribute X determines the value of Y.

What is a functional dependency? Give an example not used in the text.