This chapter’s section of “The Access Workbench” describes how to create 1:1 relationships in Microsoft 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 (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 Crow’s 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 you have created so far (WMCRM.accdb) as it exists after working through all the steps in this chapter’s section of “The Access Workbench.” (If you have not completed those actions, do so now.) Copy the WMCRM.accdb database and rename the copy WMCRM-AW05-v03.accdb. Modify the WMCRM-AW05-v03 .accdb database to implement the new relationship between VEHICLE and SALESPERSON. (Note: Copying a Microsoft Access database is discussed in Chapter 4’s section of “The Access Workbench.”)
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.