| Assignment #1:
Sample Submission
|
|
|
| Due Date: |
2:00 pm, Friday, January 18, 2013 |
| Handout: |
in PDF
(released on Jan 16)
|
|
| Assignment #2:
Relational Model
|
|
|
| Due Date: |
2:00 pm, Saturday, January 26, 2013 |
| Handout: |
in PDF
(released on Jan 22)
|
| Solution: |
in PDF
(posted on Jan 29)
|
|
| Assignment #3:
Relational Algebra
|
|
|
| Due Date: |
2:00pm, Saturday, February 2 2013 |
| Handout: |
in PDF
(released on Jan 29)
|
| Solution: |
in PDF
(posted on Feb. 10)
|
|
| Assignment #4: SQL
|
|
|
| Due Date: |
2:00 pm, Thursday, February 21, 2013
|
| Handouts: |
Assignment in PDF
(released on Feb 14)
|
| |
Starting with Oracle in PDF
(released on Feb 14)
|
| Sample data: |
in plain text
(released on Feb 14)
|
| Sample Solution: |
in hw4-db.sql
and hw4-query.sql
(posted on Feb 28)
|
|
| Assignment #5: Advanced SQL - Views, Stored Methods & Triggers
|
|
|
| Due Date: |
2:00pm, Thursday February 28, 2013 |
| Handout: |
in PDF
(released on Feb 22)
|
| Sample data: |
in hw5-db-create.sql
and hw5-db-insert.sql
(released on Feb 22)
|
| Sample data: |
in doctor_prescription_inserts.sql
(released on Feb 25)
|
| dataGen: |
Doctor_Prescription generator script in perl
(released on Feb 25)
|
| Sample solution: |
in hw5-sol.sql
(posted on Mar 3)
|
|
|
Term Project
|
|
|
| Due Date (team formation): |
2:00pm, Friday, March 22, 2013
|
| Due Date (Phase 1, SQL): |
2:00pm, Thursday, April 4, 2013
|
| Due Date (Phase 2, code): |
11:59pm, Friday, April 19, 2013
|
| Handout: |
in PDF
(released on Mar 20)
|
| Sample data: |
in plain text
(released on Mar 20)
|
| Help: |
visit Project Info page
|
|
| Assignment #6: Physical Organization & Indexing
|
|
|
| Due Date: |
2:00pm, Thursday, April 11, 2013 |
| Handout: |
in PDF
(released on Apr 1)
|
| Sample solution: |
in PDF
(posted on Apr 15)
|
|
| Assignment #7: ER Modeling & Normalization
|
|
|
| Due Date: |
6:00pm, Sunday, Apr 21, 2013 |
| Handout: |
in PDF
(released on Apr 12)
|
| Sample solution: |
in PDF
(posted on Apr 22)
|
|
