Assignments
HW1 | Homework 1: Sample Submission | Due: 05/27/2019 | PDF
HW2 | Homework 2: Relational Model & Algebra | Due: 06/04/2019 |
PDF | SOLUTION
HW3 | Homework 3: Relational Algebra | Due: 06/14/2019 |
PDF | SOLUTION
HW4 | Homework 4: SQL | Due: 06/24/2019 |
PDF | Sample Data| SOLUTION
HW5 | Homework 5: Transactions, Views and Triggers | Due: 07/19/2019 |
PDF | hw5-db.sql| hw5-insert-data.sql| doctor_prescription_inserts.sql| SOLUTION
HW6 | Homework 6: Database Design - Normalization and ER Model | Due: NONE |
PDF | SOLUTION
HW7 | Homework 7: Indexing and Concurrency Control | Due: NONE |
PDF | SOLUTION
Submission Instructions
If your submission is comprised of multiple files, create a zip file containing the files specified in
the assignment.
The submission site is better to be accessed from within Pitt's network. You can
log into the submission site
using your Pitt username (e.g., "kok25") and your PeopleSoft ID (this 7-digit number can be found under
"Demographic Information" on the Student Center).
Only your most recent submission will be graded. If you need to amend your submission before the
deadline, change the name of your file (e.g., append "-v2") and upload again.
Submit