Data Modeling

Question 1

Attribute

Answer 1

This is the formal name for a column. Describes an entity.

Question 2

What are the requirements for satisfying First Normal Form?

Answer 2

1. Have a unique identifier for each row of data
2. Don’t have any repeating columns
3. Don’t have any columns that hold more than one value

Question 3

What are the requirements for satisfying Second Normal Form?

Answer 3

1. It must meet the requirements for First Normal Form.
2. Does the data require more than one column to qualify as a unique identifier?

a. If not, skip to Third Normal Form
b. If so, are there any columns that do not directly relate to all parts of the primary key? If so, those columns must be removed and store elsewhere.

Question 4

What are the requirements for satisfying Third Normal Form?

Answer 4

1. The database must meet the requirements for first and second normal form
2. All attributes not dependent upon the primary key must be eliminated