Trying to Normalize Data Tables


It is almost always the case that if the desired data is put in a single table then there would be many blank entries and repeating groups of information. Consider




It is important to try and determine what information should be grouped together in what tables so that the tables are largely filled without repeating information. This process is called Normalization.



A Normalized Relation for Order



Notice how there are some duplicate fields, but these are to allow developing the relationships between the distinct tables.