|
| Assignment #1:
Sample Submission
|
|
|
| Due Date: |
8:00 pm, Wednesday, Sep. 14 |
| Handout (HW1): |
in PDF
(released on Sep. 6)
|
| Collaboration Policy & Plegde: |
in PDF
(released on Sep. 6)
|
|
| Assignment #2:
Database Design - ER Modeling
|
|
|
| Due Date: |
8:00 pm, Wednesday, Sep. 28 |
| Handout (HW2): |
in PDF
(released on Sep. 15)
|
| Sample Solution: |
in PDF
(released on Sep. 29)
|
|
| Assignment #3:
Relational Model, Basic SQL, & Relational Algebra
|
|
|
| Due date: |
8:00 pm, Wednesday, Oct. 12 |
| Handout (HW3): |
in PDF
(released on Sep. 30)
|
| Sample Data: |
in sample-data.sql
(released on Oct. 2)
|
| Sample Solution: |
in PDF
(released on Oct. 13)
|
|
hw3-sample-solution-db.sql
(released on Oct. 13)
|
|
hw3-solution-test-constraints.sql
(released on Oct. 13)
|
|
hw3-solution-queries.sql
(released on Oct. 13)
|
|
| Assignment #4:
Normalization
|
|
|
| Due Date: |
8:00 pm, Thursday, Nov. 10 |
| Handout (HW4): |
in PDF
(released on Oct. 27)
|
| Sample Solution: |
in PDF
(released on Nov. 29)
|
|
| Assignment #5:
Relational Algebra, Concurrency Control & Access Methods
|
|
|
| Due Date: |
8:00 pm, Saturday, Dec. 10 |
| Handout (HW5): |
in PDF
(released on Nov. 29)
|
| Sample Solution: |
in PDF
(released on Dec. 10)
|
