Assignments

All assignments (homeworks and project) must be submitted electronically via the class homework submission site: Submission site


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)