CIS303

Introduction to Databases

Lab Project - Unit E – 16 Project Points

Part I

1. Complete Unit E (pp. E-2-E-16). This will prepare you for the assignment. You will NOT turn in this part of the assignment. (0 points)

2. Turn to pp. E-21-E22 in your textbook. Complete Independent Challenge 1 (a. through i.). You do NOT need to print the relationships report. (3 points)

3. Field lengths are not specified, so use these:

Field Name	Length
FirstName	10
LastName	20
Street	30
City	20
State	2
Zip	5
CustNo	3
SchoolNo	2
Description	30
SerialNo	5
SchoolName	20

Be sure you look at all of the tables and set these lengths.

Part II

1. Turn to page E-23 in your textbook. Complete Independent Challenge 3 and the associated Advanced Challenge Exercise. (13 points)

2. You will create your own data for each of your tables. Each table should have a minimum of 5 records.

When you are finished, zip Music Store-E.mdb and Blood Drive-E.mdb and send them to me. You will also send me either a Word file or an Excel with your database design. Name this file Design.