Project 3 Overview | Create Database | Relationships & Data

Establishing relationships and entering data

 

1. Define the relationships between your tables by creating two links:

• link the sailorID field in tableSailor with the sailor field in the tableReservations
• link the boatID field in tableBoat with the boat field in tableReservations

Your relationship display will look like this (review how to define relationships in lab 11):

* if the infinity symbol doesn't appear, it probably means that you didn't check the enforce referential integrity checkbox. You can double-click on the relationship line to edit the relationship and fix that.

 

2. Populate your tables with this data:

 

SID	name	rating	age
1	Dustin	7	45.0
2	Brutus	1	33.0
3	Laura	8	55.5
4	Andy	8	25.5
5	Rusty	10	35.5
6	Horatio	7	35.0
7	Zelda	10	16.0
8	Horatio	9	35.0
9	Amy	3	25.5
10	Bob	3	63.5

 

 

boatID	boatName	color
1	Interlake	blue
2	Interlake	red
3	Clipper	green
4	Marine	red

 

reservationID	reservationDate	duration	boat	sailor
1	6/10/08	60	1	1
2	6/10/08	60	2	1
3	6/8/08	60	3	1
4	6/7/08	90	4	1
5	7/10/08	90	2	2
6	7/6/08	60	3	2
7	7/12/08	90	4	2
8	8/5/08	60	1	6
9	8/8/08	60	2	6
10	8/8/08	60	3	7

3. Add yourself as a sailor and make a reservation for the blue Interlake boat for 2 hours on June 20, 2008.

4. Upload your database to Catalyst Collect It  (in the Project 3A dropbox). (Keep a copy to use for part B).

Points will be assigned as follows:

You turned in a database (an Access file) by the due date: 10 points

Your database has 3 tables with the correct fields: 10 points

Your fields have the correct data types: 10 points

Your tables have the correct data: 10 points

You've entered data for yourself and your reservation correctly: 10 points

TOTAL POINTS POSSIBLE: 50