Don just received a request from Paul to develop a database for a new pharmacy that Paul is opening.

Don just received a request from Paul to develop a database
for a new pharmacy that Paul is opening in Edmonton, Alberta, Canada. Because
the data collected about customers, employees, and drugs is slightly different
in Canada, Don decides to create the databases simultaneously, but separately,
so he can account for the individual differences in each version. Don wants you
to create the database for Hudson Bay Pharmacy. (You will create nine tables in
this exercise using the skills you have learned so far. You will create three more
tables in the Level 2 Steps To Success exercises.) He will
»

Don just received a request from Paul to develop a database
for a new pharmacy that Paul is opening in Edmonton, Alberta, Canada. Because
the data collected about customers, employees, and drugs is slightly different
in Canada, Don decides to create the databases simultaneously, but separately,
so he can account for the individual differences in each version. Don wants you
to create the database for Hudson Bay Pharmacy. (You will create nine tables in
this exercise using the skills you have learned so far. You will create three more
tables in the Level 2 Steps To Success exercises.) He will provide you
additional information so you know how to account for the differences in the
Canadian version of the database.

Complete the following:

Create the following tables in the Hudson database using the
method you prefer: tblClass, tblCustomer, tblHealthPlan, and tblHousehold. Be
certain that each table includes a primary key and the necessary fields. Also,
be certain to set the field properties as necessary to collect the correct
data. Fields should include appropriate captions and field descriptions. These
tables have the same requirements as the ones in the 4Corners database, with
the following exceptions:

»