| Assignment #0:
Sample Submission
|
|
|
| Due Date: |
12:00 pm (noon), Tuesday, Jan 17, 2012 |
| Handout: |
in PDF
(released on Jan 12)
|
|
| Assignment #1:
Relational Model
|
|
|
| Due Date: |
12:00 pm (noon), Tuesday, Jan 24, 2012 |
| Handout: |
in PDF
(released on Jan 17)
|
| Solution: |
in PDF
(posted on Jan 25)
|
|
| Assignment #2:
Relational Algebra
|
|
|
| Due Date: |
2:00pm, Tuesday, Jan 31, 2012 |
| Handout: |
in PDF
(released Jan 24)
|
| Solution: |
in PDF
(posted on Feb 8)
|
|
| Assignment #3: SQL
|
|
|
| Due Date: |
2:00 pm, Wednesday, Feb. 8, 2012 (New)
|
| Handouts: |
Assignment in PDF
(released on Jan. 31)
|
| |
Starting with Oracle in PDF
(released on Jan. 31)
|
| Sample data: |
in plain text
(released on Jan. 31)
|
| Sample Solution: |
in hw3-db.sql
and hw3-query.sql
(posted on Feb 8)
|
|
| Assignment #4: Advanced SQL - Views
|
|
|
| Due Date: |
2:00pm, Tuesday, Feb 14, 2012 |
| Handout: |
in PDF
(released on Feb 8)
|
| Sample data: |
in Text
(released on Feb 8)
|
| Sample solution: |
in Text
(posted on Feb. 27)
|
|
| Assignment #5: Advanced SQL - Triggers
|
|
|
| Due Date: |
2:00pm, Tuesday, Feb 21, 2012 |
| Handout: |
in PDF
(released on Feb 15)
|
| Sample solution: |
in Text
(posted on Feb. 27)
|
|
|
Term Project
|
|
|
| Due Date (team formation): |
11:59pm, Monday, March 12, 2012
|
| Due Date (Phase 1): |
2:00pm, Friday, March 30, 2012
(New)
|
| Due Date (Phase 2, code): |
12:00pm (noon), Friday, April 20, 2012
(New)
|
| Handout: |
in PDF
(released on Mar 1)
|
| Sample data: |
in plain text
(released on Mar 2)
|
| Help: |
visit Project Info page
|
|
| Assignment #6: Normalization
|
|
|
| Due Date: |
2:00pm, Tuesday, Mar 20, 2012 |
| Handout: |
in PDF
(released on Mar 13)
|
| Sample solution: |
in PDF
(posted on Mar 21)
|
|
| Assignment #7: ER Modeling
|
|
|
| Due Date: |
2:00pm, Wednesday, Mar 28, 2012 (New) |
| Handout: |
in PDF
(released on Mar 21)
|
| Sample solution: |
in PDF
(posted on Apr. 19)
|
|
| Assignment #8: Physical Organization & Indexing
|
|
|
| Due Date: |
2:00pm, Thursday, April 19, 2012 (New) |
| Handout: |
in PDF
(released on April 4)
|
| Sample solution: |
in PDF
(posted on April 19)
|
|
| Assignment #9: Final Review
|
|
|
| Due Date: |
2:00pm, Thursday, April 26, 2012 |
| Handout: |
in PDF
(released on April 19)
|
| Sample solution: |
in PDF
(posted on TBD)
|
|
