Normalization:
| The relational model requires that all of the information be stored in
two-dimensional tables.
| The columns are called attributes, or fields. These are the names of
the general categories of information that will be stored. Each
fieldname within an individual table must be unique. The individual
items stored in the fields can repeat.
| The rows are called tuples. The rows are where the actual
"information" or data items get stored. Each row in a table
must be unique.
| Make sure that you always name your tables. | |
| Table Name | ||
| Unique Field #1 | Unique Field #2 | Unique Field #3 |