Homework Problems
For every homework, please turn in
Paper copies of
SQL code and results for the lab problems
Answers to the discussion questions
Solutions to the text book problems
| HW |
Due on |
Laboratory |
Discussion Questions |
Problems |
| 0
| 9/10 |
Background Survey |
|
|
| 1. |
9/24 |
Lab 1
|
3.18,4.17,4.33 |
3.4,4.22*,4.37* |
| 2. |
10/8 |
Lab 2
|
5.7,6.18,6.27 |
5.8,6.20** |
| 3. |
11/5 |
Lab 3
|
7.7,8.14,8.41 |
7.9,8.2 |
| 4 |
11/26 |
Lab 4
|
9.29,15.12,16.14 |
9.8*,15.10,16.Part2.7* |
* 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).
** 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.
Laboratory Resources