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.