Shortcut Navigation:

Customer Table Quiz

A foreign key is:

You are creating a banking database to track customer loans. The bank will, of course, have many customers, each of whom may take out one or more loans, while each loan may be associated with only one customer (there are no joint accounts). What is the re

In a one-to-many relationship between Companies and Employees, which field is found in both tables?

Which of the following ensures that records in related tables are consistent with one another? For example, it ensures that you cannot add a record with an invalid foreign key.

How would you delete a relationship between tables in the Relationships window?

In a Customers tables, what does a plus sign next to the CustomerID field mean?

What is required of the fields that join two tables?

Assume a one-to-many relationship between the Customers table and the Loans table, with referential integrity in effect. What happens when you attempt to delete a customer ID from the Customer table that still has entries in the Loans table?

Which of the following is true when viewing a main form and its associated subform in the Form Design view?

Which of the following relationships does not belong in a database based on a professional sports league such as football or basketball?