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.