Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer

Exercise 2

In this exercise, you will build the Cape Codd database used for the SQL examples in Chapter 2. The Access 2013 tables and relationships are shown in Figure 2-2.
A. Create a new Access 2013 database named Cape-Codd.accdb.
B. The column characteristics for the RETAIL_ORDER table are shown in Figure A-51. Create the RETAIL_ORDER table.
C. The column characteristics for the SKU_DATA table are shown in Figure A-53. Create the SKU_DATA table.
D. The column characteristics for the ORDER_ITEM table are shown in Figure A-54. Create the ORDER_ITEM table.
E. The data for the RETAIL_ORDER table are shown in Figure 2-5. Populate the RETAIL_ORDER table.
F. The data for the SKU_DATA table are shown in Figure 2-5. Populate the RETAIL_ORDER table.
G. Create the relationship between the RETAIL_ORDER and ORDER_ITEM tables. Be sure to enforce referential integrity.
H. Create the relationship between the SKU_DATA and ORDER_ITEM tables. Be sure to enforce referential integrity.
I. The data for the ORDER_ITEM table are shown in Figure 2-4. Populate the RETAIL_ORDER table.
J. Why did you enter the ORDER_ITEM data only after creating the relationships between the tables?
K. Create a QBE query to display Department and Buyer in the SKU_DATA table. Save the query as QBE-Query-A-RQ-01.