Take Home Exercise #5

Take Home Exercise #5

On Monday, May 19 at the beginning of class before the test you need to hand in the answer to the Excercise that we did part of in class on 4/17.

I want the non-navigation table query design (only) for both parts of E6.1. In other words fill out the following table for each part of 6.1

Table
1.What attributes do users require in the query output?
2.What criteria will be used to generate the output? What attributes will be used in the criteria?
3.What foreign keys link the information in this table to the primary keys of other tables in the query?

You can do the assignment in groups of up to 3 students. Each group should hand in a single document with each team members' name listed.

This assignment will be worth 3 points of the class total. The point is for you to practice and I expect most of you to do very well!