Creating relationships

[Terri Pecora]

Based on your description below, here is my recommendation
for your Database Design ...

Tables:
Activity Table - PK Activity ID, Activity (1, Football)
Student Table - PK Student ID, Student Name, Grade Level
(1, John Doe, 4)
Question Table - PK Question ID, Activity ID, Question
(1, 1, How many yards did you run?)
Responses Table - PK Response ID, Student ID, Activity ID,
Question ID, Hours
(1, 1, 1, 1, 2)

Relationships:
Activity Table.Activity ID -> Question Table.Activity ID
Activity Table.Activity ID -> Response Table.Activity ID
Student Table.Student ID -> Response Table.Student ID
Question Table.Question ID -> Response Table.Question ID

Thanks
Terri

 

[Terri Pecora]

The Response table is where the students would enter there
activity input.

The Question table would just be a repository for the
questions.

1 is the primary key on the activity table and Football is
the activity description.

The relationships are as follows:
1 student may have many responses/input
1 activity may have many questions
1 question may have many responses/input
1 activity may have many responses/input

Thanks
Terri