graphic2
graphic1

Third Normal Form (3NF)

Definition of Third Normal Form:

Third Normal Form can be summarized by a pun: "the Key, the whole Key and nothing but the Key, so help me Codd!"

 

A normalized database uses Primary Keys to create Relationships. The Table that is in Third Normal Form has only Keys.

 

Primary Keys and Foreign Keys, Only

When a database has been designed in Third Normal Form, the Tables that summarize the data should be only Primary Keys.

 
In this lesson, tblReceipt will be related to tblMovieRented by a common Key:

CustomerID.

 

That's a very, very brief explanation of normalizing a database.

 

Let's build the Receipt Form, then come back to these concepts again.

Microsoft Access: Example of Table in Third Normal Form