Chapter 6

Question 1

Nomalization

Answer 1

A process that assigns attributes to entities so that data redundancies are reduced or eliminated

Question 2

denormalization

Answer 2

• A process by which a tables is changed from a higher-level normal form to a lower-level normal form, usually to increase processing speed
• Potentially yields data anomalies

Question 3

prime attribute

Answer 3

• a key attribute

- an attribute that is part of a key or is the whole key

Question 4

key attributes

Answer 4

attributes that form a primary key

Question 5

nonprime attribute

Answer 5

attribute that is not part of a key

Question 6

unnormalized data

Answer 6

• Raw data in its original state

- might contain redundant data and/or other data anomalies not found on normalized data relations