Lab 2

Part I – due Tuesday, February 7, 2006

The website for our text has the Chapter2.mdb Access database on it.

1.

Create a SQL_Server database named Chapter2 which has the tables

ORDER_ITEM, RETAIL_ORDER, SKU_DATA, and WAREHOUSE in it.

Make your column names and data types match those in the Access database.

After creating each table, obtain a screen capture of the Table Properties.

2.

Turn in the four screen captures. Staple your pages together in the following order: ORDER_ITEM, RETAIL_ORDER, SKU_DATA, WAREHOUSE.

Part II – due Thursday, February 9, 2006

1.

Enter the data that is in the Access database into your SQL_Server tables directly or using SQL statements. Enter the data only for the four tables you created in Part I. After entering data into each table, obtain a screen capture of each table’s contents

2.

Create the INVENTORY and NDX tables. Make your column names and data types match those in the Access database. After creating each table, obtain a screen capture of the Table Properties.

3.

Create the relationship diagram that matches the Access database diagram.

After creating the relationship diagram, obtain a screen capture of the diagram.

4.

Turn in the seven (7) screen captures. Staple your pages together in the following order: ORDER_ITEM, RETAIL_ORDER, SKU_DATA, WAREHOUSE, INVENTORY, NDX, relationship diagram.