Database Normalization

Question 1

1NF

Answer 1

• Each table cell should contain a single value

* Each record needs to be unique

Question 2

2NF

Answer 2

• Be in 1NF

* All the non-key columns are dependent on the table’s primary key

Question 3

3NF

Answer 3

• Be in 2NF

* Has no transitive functional dependencies

Question 4

What is a transitive functional dependency?

Answer 4

When a change to a non-key column might cause another non-key column change

Question 5

What does BCNF stand for?

Answer 5

Bryce-Codd Normal Form

Question 6

BCNF

Answer 6

• Be in 3NF

* Non-Key data depend on the key[s] and nothing but the keys

Question 7

4NF

Answer 7

• Be in BCNF
• Not contain more than 1 multi valued dependency

IE - Course depends on Professor and Book

Question 8

5NF

Answer 8

also known as Project-Join NF

• Be in 4NF
• every non-trivial join dependency in that table is implied by the candidate keys

Question 9

6NF

Answer 9

• Be in 5NF

* no nontrivial join dependencies at all

Question 10

What are some ways to Denormalize a database?

Answer 10

Using Views

OLAP Cubes

Question 11

How can you use a GUID as a Clustered Index?

Answer 11

Create the GUID using NEWSEQUENTIALID()