Normalization

Question 1

Normalization

Answer 1

Process for evaluating and correcting table structures to minimize data redundancies.

Question 2

Normal Forms

Answer 2

Stages of normalization. Structurally, higher forms are desirable but require more relational joins.

Question 3

Denormalization

Answer 3

Produces a lower normal form which increases query performances but also creates data redundancy.

Question 4

Relation

Answer 4

aka Table

Does not allow duplicate tuples

Question 5

Prime Attribute

Answer 5

Attribute that is part of the key

aka Key Attribute

Question 6

Nonprime Attribute

Answer 6

Not part of any candidate key

aka Nonkey Attribute

Question 7

Repeating Group

Answer 7

Group of multiple entries of same type can exist for any single key attribute occurrence

Question 8

Dependency Diagram

Answer 8

Show relationships among a table’s attributes

Question 9

Atomicity

Answer 9

An attribute displays atomicity when it cannot be further divided (simple attribute)

Question 10

Granularity

Answer 10

Level of detail represented by values stored in a table’s row