Database Normalization Flashcards Preview

70-464 Certification > Database Normalization > Flashcards

Flashcards in Database Normalization Deck (11)
Loading flashcards...
1

1NF

* Each table cell should contain a single value
* Each record needs to be unique

2

2NF

* Be in 1NF
* All the non-key columns are dependent on the table's primary key

3

3NF

* Be in 2NF
* Has no transitive functional dependencies

4

What is a transitive functional dependency?

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

5

What does BCNF stand for?

Bryce-Codd Normal Form

6

BCNF

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

7

4NF

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

IE - Course depends on Professor and Book

8

5NF

also known as Project-Join NF
* Be in 4NF
* every non-trivial join dependency in that table is implied by the candidate keys

9

6NF

* Be in 5NF
* no nontrivial join dependencies at all

10

What are some ways to Denormalize a database?

Using Views
OLAP Cubes

11

How can you use a GUID as a Clustered Index?

Create the GUID using NEWSEQUENTIALID()