New Perspectives on Microsoft Access 2010, Comprehensive 1st Edition by Joseph Adamski,Kathy Finnegan

تمرين 1

Figure 9-30 lists the fi eld names from two tables: tblDepartment and tblEmployee.

a. What is the primary key for each table?
b. What type of relationship exists between the two tables?
c. Is an inner join possible between the two tables? If so, give one example of an inner join.
d. Is an outer join possible between the two tables? If so, give one example of an outer join.
e. Is a self-join possible for one of the two tables? If so, give one example of a self-join.