Access: Now Playing (Page 1) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

Primary Key: MovieRentedID Foreign Keys: ReceiptID. CustomerID and MovieID. These keys are outside (foreign) to this table. These Foreign Keys are the Primary Key in their own tables.

Home -> View ->Design View Third Normal Form (3NF) Third Normal Form Definition: Third Normal Form requires that the tables meet the rules for Second Normal Form: there should be a separate table for values that can be used by multiple tables. Further, the tables must be related to each other by a Foreign Key.   Edgar F. Codd, who developed the concept of Normalized Database design, stated that everything that wasn't the Primary Key should be dependent on "the key, the whole key, and nothing but the key."   Purpose: Eliminate fields that do not depend on the key.   Process: Create a summary table. For example, the table on this page contains key numbers, only.   Memo to self: Computers eat numbers a lot faster than processing or parsing text.