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

Design -> Primary Key Table Design There are a few rules that help define good relational database tables. Each rule is called a Normal Form.   Normalizing a database defines the tables and the table relationships. The rules are simple: minimize duplicate data and protect the data integrity. Data, data, data.   Most databases strive for 3rd Normal Form, although there are six Normal Forms by definition. Each form, or rule, is more restrictive.   First Normal Form Definition: First Normal Form requires that each table should have only one value for each field in a record.   Purpose: No repeating groups.   Process: Create a separate table for each different collection. Identify each collection with a Primary Key.