| HW | Due on | Laboratory (50%) | Discussion Questions (20%) | Problems (30%) |
|---|---|---|---|---|
| 0 | 1/27/2009 | Background Survey | ||
| 1. | 2/10/2009 | Lab 1 | 3.11, 4.25, 4.33 | 3.12, 4.12*, 4.36* |
| 2. | 2/24/2009 | Lab 2 | 5.16, 6.19, 6.26 | 5.13, 6.26** |
| 3. | 4/7/2009 | Lab 3 | 7.19, 8.15, 8.45 | 7.16, 8.3 |
| 4 | 4/21/2009 | Lab 4 | 9.28, 15.35, 16.42 | 9.18*, 15.10, 16.Part2.8* |
* Please provide your in answer in an SQL expression. Please read sections 4.3 and 4.4 on
how to build SQL expressions and using the critical questions for query formulation (Table 4.20
on Page 102). In addition, we expect you to hand test your SQL expression using the Conceptual
Evaluation Process (Fig. 4.2 on Page 99). We will take off points if the critical questions and the hand test is not provided.
** Please state your assumptions clearly. Be sure to show the steps.
Grading will be done based on the process rather than on the final diagram.