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

Chapter 5. Access workbench exercises,

What would the IE Crow's Foot E-R diagrams look like for AW 5.1,5.2 5.3

Access Workbench Exercises AW.5.1 Using an IE Crows Foot E-R diagram, draw a database design for the Wedgewood Pacific Corporation (WPC) database as completed at the end of Section 3 of The Access Workshop. 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. AW.5.3 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 Kroenke and Auer Database Concepts 3.5 The Access Workbench Section 5 2007, 200, 2009 by Prentice Hall, David Kroenke, and David Auer Page 5-12 Wallingford Motors can have one and only one vehicle as a demo car. Suppose that the rule has been changed so that (1) each salesperson can have one or more cars as demo vehicles, and (2) each demo vehicle can be shared by two or more salespersons. 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). Copy the WMCRM.accdb database and rename the copy as WMCRM-AW05-v03.accdb (NOTE: Copying an Access database is discussed in Section 4 of The Access Workbench). C. Modify the WMCRM-AW05-v03.accdb to implement the new relationship between VEHICLE and SALESPERSON.