Book: Database Concepts 7th edition by David M Kroenke, David Suer.

Chapter 5. Access workbench exercises

AW.5.2 This chapters The Access Workshop described how to create 1:1 relationships in Access. In particular, we added the business rule that each salesperson at Wallingford Motors can have one and only one vehicle as a demo car. Suppose that the rule has been changed so that each salesperson can have one or more cars as demo vehicles.

A. Using an IE Crows Foot E-R diagram, redraw the database design in Figure AW-5-1 to show the new relationship between VEHICLE and SALESPERSON. Which table(s) is (are) the parent(s) in the relationship? Which table(s) is (are) the child(ren)? In which table(s) do you place a foreign key?

B. Start with the Wallingford Motors database that youve created so far (WMCRM.accdb) as it exists after working through all the steps in this sections The Access Workshop (If you havent completed these actions, do so now). Make two copies of the WMCRM.accdb database (Note: Copying an Access database is discussed in Section 4 of The Access Workbench). Name the first copy as WMCRM-AW05-v01.accdb, and name the second copy as WMCRM-AW05-v02.accdb.

C. Modify the WMCRM-AW05-v02.accdb database to implement the new relationship between VEHICLE and SALESPERSON