|
| Assignment #1:
Sample Submission
|
|
|
| Due date: |
8:00 pm, Monday, Jan. 24 |
| Handout (HW1): |
in PDF
(released on Jan. 13)
|
|
| Assignment #2: Database Design - ER Modeling
|
|
|
| Due Date: |
8:00 pm, Monday, Feb 7 |
| Handout (HW2): |
in PDF
(released on Jan 25)
|
| Sample Solution: |
in
PDF (Feb 9)
|
|
| Assignment #3 (HW3): Relational Model, SQL DDL & Relational Algebra
|
|
|
| Due Date: |
8:00 pm, Wednesday, Mar 2
New
|
| Handout (HW3): |
in PDF
(released on Feb. 12)
|
| Sample data: |
in TXT
(released on Feb. 12)
|
| Symbols data: |
in TXT
(released on Feb. 12)
|
| Sample Solution: |
hw3-sol.pdf (released on Mar. 3)
|
|
hw3-sol-db.sql (released on Mar. 3)
|
|
| Assignment #4 (HW4): Database Design - Normalization
|
|
|
| Due Date: |
8:00 pm, Wednesday, Mar 30
New
|
| Handout (HW4): |
in PDF
(released on Mar. 20)
|
|
hw4-sol.pdf (released on Apr. 1)
|
|
| Assignment #5 (HW5): Views, Triggers, Functions and Procedures
|
|
|
| Due Date: |
8:00 pm, Monday, Apr 18
|
| Handout (HW5): |
in PDF
(released on Apr. 8)
|
| HW3 Sample Solution: |
hw3-sol-db.sql (released on Mar. 3)
|
| HW5 Sample Solution: |
hw5-sol.sql (released on Apr. 22)
|
|
| Practice Assignment: Data Storage, Indexing & Concurrency Control
|
|
|
| Due Date: |
None |
| Handout (HW6): |
in PDF
(released on Apr 22)
|
| Sample Solution: |
in
PDF (released Apr. 22)
|
