Project Guidelines:
- Create a table by the name MEMBERS.
Each member is a person who comes to the gym and does different
workouts. This table is not available that is why you have to create
yourself and try to include as many relevant fields as you can; [10 pts]
- All you have to do is to create
relationships among the tables and EXPLAIN them why you chose those
relationship types. For example, if you choose one relationship between
tables A and B as one to many relationship, then explain why do you
think its a one to many relationship. [25 pts]
- Create a switchboard for the database
and try to include as many items as you can; [15 pts]
- Do the following queries:
- Find out how many members do
'Beginners' workout. [10 pts]
- Find out who does the 'Tai Chi'
workout. [10 pts]
- Find out workout details for
'Beginners' and 'Tai Chi' members. [15 pts]
- Create a parameter query to find out
description for any exercise. [15 pts]
DOWNLOAD NOW Due date for
project: Saturday, 21st
January 2006 - 1:00 pm
|