|
Assignment #1:
Sample Submission
|
|
Due Date: |
8:00 pm, Tuesday, Sept. 12, 2017 |
Handout (HW1): |
in PDF
(released on Sept. 6)
|
|
Assignment #2: Relational Model & Algebra
|
|
Due Date: |
8:00pm, Wednesday, Sep. 27, 2017 |
Handout (HW2): |
in PDF
(released on Sep. 19)
|
Solution: |
in PDF
(posted on Sep. 28)
|
|
Assignment #3: Relational Algebra
|
|
Due Date: |
8:00pm, Thursday, Oct. 5, 2017 |
Handout (HW3): |
in PDF
(released on Sep. 28)
|
Solution: |
in PDF
(posted on On Oct. 6)
|
|
Assignment #4: Basic SQL
|
|
Due Date: |
8:00 pm, Friday, Oct. 13, 2017
|
Handout (HW4): |
Assignment in PDF
(released on Oct. 6)
|
|
Starting with Oracle in PDF
(released on Sep. 22)
|
Sample data: |
in plain text
(released on Oct. 7)
|
Sample Solution: |
in hw4-db.sql
and hw4-queries.sql
(posted on Oct. 14)
|
|
Assignment #5: Advanced SQL
|
|
Due Date: |
5:00 pm, Saturday, Oct. 21, 2017 <--- New Date
|
Handouts (HW5): |
Assignment in PDF
(released on Oct. 14)
|
Scripts: |
in
hw5-db-insert.sql
(released on Oct. 14)
|
Sample Solution: |
in
hw5-solutions.sql
(posted on Oct. 22)
|
|
Term Project
|
|
Due Date (team formation): |
11:59pm, Thursday, Nov. 2, 2017
|
Due Date (Phase 1, DB Schema): |
11:59pm, Thursday, Nov. 16, 2017
|
Due Date (Phase 2, SQL Queries): |
11:59pm, Friday, Dec. 1, 2017
|
Due Date (Phase 3, Code): |
11:59pm, Sunday, Dec. 10, 2017
|
Handout: |
in PDF
(released on Oct. 26)
|
github instructions: |
in PDF
(released on Oct. 26)
|
|
Assignment #6: DB Design
|
|
Due Date: |
8:00 pm, Wednesday, Nov. 15, 2017  
|
Handouts (HW6): |
Assignment in PDF
(released on Nov. 3)
|
Sample Solution: |
in
PDF
(posted on Nov. 29)
|
|
Assignment #7: Physical Storage, Indexing & Transactions
|
|
Due Date: |
6:00 pm, Thursday, Dec. 7, 2017 <--- New Date
|
Handouts (HW7): |
Assignment in PDF
(released on Nov. 20)
|
Sample Solution: |
in
PDF
(posted on Dec. 9)
|
|