|
| Assignment #1:
Sample Submission
|
|
|
| Due Date: |
8:00 pm, Friday, Sep 4 |
| Handout (HW1): |
in PDF
(released on Aug 26)
|
|
| Assignment #2:
Relational Model, SQL DDL & Basic DML
|
|
|
| Due Date: |
8:00 pm, Tuesday, Sep 15 |
| Handout (HW2): |
in PDF
(released on Sep 3)
|
| Sample data: |
in TXT
(released on Sep. 3)
|
| Sample Solution: |
hw2-db.sql (released on Sep. 16)
hw2-insert.sql (released on Sep. 16)
hw2-query.sql (released on Sep. 16)
|
|
| Assignment #3:
Relational Model & Relational Algebra
|
|
|
| Due Date: |
8:00 pm, Friday, Sep 25 |
| Handout (HW3): |
in PDF
(released on Sep 16)
|
| Full specifications: |
in TXT
(released on Sep. 16)
|
| Sample Solution: |
hw3-sol.pdf (released on Sep. 26)
|
|
| Assignment #4:
SQL DML and Views
|
|
|
| Due Date: |
8:00 pm, Thursday, Oct 8 |
| Handout (HW4): |
in PDF
(released on Sep 28)
|
| DB Schema & Sample Data: |
hw4-cstech-db.sql (released on Sep. 28)
hw4-cstech-insert.sql (released on Sep. 28)
|
| Sample Solution: |
hw4-query.sql (released on Oct 9)
|
|
| Assignment #5: Triggers, Functions, Procedures, and Transactions (Project Phase 1)
|
|
|
| Due Date: |
8:00 pm, Thursday, Oct 29 |
| Handout (HW5): |
in PDF
(released on Oct 15) (updated on Oct 25)
|
| Sample Data: |
in
TXT (released on Oct 19)
|
| github instructions: |
in PDF
(released on Oct. 15)
|
| Sample Solution: |
hw5-db.sql (released on Oct 31)
hw5-insert.sql (released on Oct 31)
hw5-query.sql (released on Oct 31)
hw5-triggers.sql (released on Oct 31)
|
|
| Assignment #6: Database Design - Normalization
|
|
|
| Due Date: |
8:00 pm, Thursday, Nov 12 |
| Handout (HW6): |
in PDF
(released on Nov 3)
|
| Sample Solution: |
in
PDF (Nov 16)
|
|
| Assignment #7: Conceptual Database Design - E-R Model
|
|
|
| Due Date: |
8:00 pm, Friday, Nov 20 |
| Handout (HW7): |
in PDF
(released on Nov 12)
|
| ER-to-Relational Mapping Algorithm: |
in
PDF (released Nov. 12)
|
| Sample Solution: |
in
PDF (released Nov. 22)
|
|
| Assignment: Term Project
|
|
|
| Due Date: |
8:00 pm, Tuesday, Nov 24 |
| Handout (Project): |
in PDF
(released on Nov 12)
|
| Startup tutorial: |
in PDF
(released on Nov 12)
|
|
| Practice Assignment: Data Storage, Indexing & Concurrency Control
|
|
|
| Due Date: |
None |
| Handout (HW8): |
in PDF
(released on Nov 22)
|
| Sample Solution: |
in
PDF (released Nov. 22)
|
