Example of a Table with Key Data: A Primary Key and 3 Foreign Keys Primary Keys and Relationships What is a Normalized database? Normalizing a database defines the Table design and how the Tables are related.   Why Does This Matter? Normalizing a database minimizes duplicate data and protects the data integrity. The Tables are small and functional. There should be a separate Table for each collection.   Plan: We will create two new Tables that will be the Record Sources for the Receipt Form and Receipt Subform. The Receipt Subform will inherit three Key Fields from the Receipt Form. So the Table for the Receipt Subform, tblMovieRented, has to be designed with that in mind   What Are the Steps? Create a Table for the Receipt Form and another Table for the Receipt Subform. These Tables will be joined by a matching Key: ReceiptID.