Chat with AI
New Perspectives on Microsoft Access 2010, Comprehensive 1st Edition by Joseph Adamski,Kathy Finnegan
Edition 1ISBN: 978-0538798471New Perspectives on Microsoft Access 2010, Comprehensive 1st Edition by Joseph Adamski,Kathy Finnegan
Edition 1ISBN: 978-0538798471 Exercise 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.
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.
Explanation
Verified
Verified
New Perspectives on Microsoft Access 2010, Comprehensive 1st Edition by Joseph Adamski,Kathy Finnegan
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
