• Each containing a primary key
• The second table should contain a foreign key (common key)
• Enter 10 records into first table
• Enter 5 records into second related table
  • Each of the 5 records should contain a valid value foreign key.

2. Create a query containing the two primary fields each gotten from a different table.

• Print the query

3. Create a 1 to Many relationship using the primary and foreign key and enforce referntial integrity.

4. Create a new query containing the two primary fields

• aPrint the query

5. Describe the differences of the queries and what caused those differences.