CS401A's Midterms: Info Management Module 05

Question 1

Fundamentals

is raw data in its original state.

Answer 1

• An unnormalized data

Question 2

Fundamentals

is an undesirable consequence of a data modification.

Answer 2

A data anomaly

Question 3

Fundamentals

is a process that assigns attributes to entities so that data redundancies are reduced or eliminated.

Answer 3

• Normalization

Question 4

* Objectives of

Each table/relation represents a single object.

Answer 4

normalization:

Question 5

Fundamentals

○ Each table has no

Answer 5

insertion, update, or deletion anomalies.

Question 6

Fundamentals

○ All nonprime attributes (not part of a key) in a table are

Answer 6

dependent on the primary key.

Question 7

Fundamentals

• Each rule in database normalization is called a

Answer 7

• normal form.

Question 8

Characteristics
There are no repeating groups and the primary key is identified.

Answer 8

Normal Form
First normal form (1NF)

Question 9

Characteristics
1NF and all the columns depend on the table’s primary key.

Answer 9

Normal Form
Second normal form (2NF)

Question 10

Characteristics
2NF and there are no non-key attributes determined by another non-key attribute.

Answer 10

Normal Form
Third normal form (3NF)

Question 11

Characteristics
Every determinant is a candidate key (special case of 3NF).

BONUS

Answer 11

Normal Form
Boyce-Codd normal form (BCNF)

Question 12

Characteristics
3NF and no independent multivaluted dependencies.

BONUS

Answer 12

Normal Form
Fourth normal form (4NF)

Question 13

is considered the highest level necessary for most applications.

Answer 13

3NF