CS 364 Homework
| Homework 1
Due Date: 08/31/06
Chapter 1 - Review Questions # 2, 4, 5, 6.
|
| Homework 2
Due Date: 09/07/06 Chapter 3 - (1) Review Question # 5 (2) Problems - Use the database shown in Figure P3.1 to work problems 1 through 7 |
| Homework 3
Due Date: 9/28/06 Chapter 4 - (1) Review Question : Given the conceptual model in Figure Q4.5, create two external models (2) Problems Questions # 1, 2, 3 - Use Figure P4.1 Chapter 5 (3) Problems Question # 1 |
| Homework
4
Due Date: October 26 Chapter 6 - Review Questions # 1 to 6 |
| Final Homework
5
Due Date: November 7 Refer to the ERD given in class (Year-Gift-Donor). Write the following queries in (a) SQL, (b) relational algebra (c) tuple relational calculus (d) domain relational calculus: 1, List all fields of donor 2, List the first and last names of all donors 3, List the phone numbers of donors 106 and 125 4, List the amount given by each donor for each year
|
