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

 

Home -> View ->Datasheet View

First Normal Form

Try it: Review the Table

The Customer table has one row for each customer. Even though many customers may have the same last name, each customer has a unique CustomerID.

 

The Customer table stores customer data, only. There are no fields for movies rented, date rented, or price.

 

This table is in First Normal Form.

The customer data is separate from the movie or rental data. The customer table identifies each record in the collection with a Primary Key.

   

 

  Microsoft Access 2007 Exam 77-605 Topic: 1. Structuring a Database

  1.1.3.   Define tables in databases: Define tables based on available data