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