chapter 2 quiz 3

Question 1

A table that meets the requirements of a relation is said to be in which normal form?

A) Relational normal form (RNF)

B) First normal form

C) Second normal form

D) Boyce-Codd normal form

E) Domain/key normal form

Answer 1

B) First normal form

Question 2

To be considered a composite key, a key must contain at least two attributes. (T/F)

Answer 2

True

Question 3

The primary key is used both to identify unique rows in a relation and to represent rows in relationships. (T/F)

Answer 3

TRUE

Question 4

Any table that meets the definition of a relation is said to be in second normal form.

Answer 4

False

Question 5

When the primary key of one relation is placed into a second relation, it is called a:

A) field key.

B) referential integrity.

C) foreign key.

D) candidate key.

E) relocated key.

Answer 5

C) foreign key.