Assignment #1:
Sample Submission
|
|
Due Date: |
8:00 pm, Thursday, January 23, 2020 |
Handout: |
in PDF
(released on Jan. 15)
|
|
Assignment #2:
SQL Review
|
|
Due Date: |
8:00 pm, Thursday, February 6, 2020 |
Handout: |
in PDF
(released on Jan. 22) |
Sample Data: |
in TXT
(released on Jan. 22) |
Ticket Generator: |
in TXT
(released on Jan. 22) |
Oracle Server Guide: |
in PDF
(released on Jan. 22) |
IDE Tools Guide: |
in PDF
(released on Jan. 22) |
Sample Solution: |
db.sql in TXT,
query1.sql in TXT, and
query2.sql in TXT
(posted on Feb. 10) |
|
Assignment #3:
Theory of Recovery & Serializability
|
|
Due Date: |
8:00 pm, Thursday, February 13, 2020 |
Handout: |
in PDF
(released on Feb. 06)
|
Sample Solution: |
in PDF
(posted on Feb. 17)
|
|
Assignment #4: Physical Storage & Access Methods
|
|
Due Date: |
8:00 pm, Thursday February 27, 2020
|
Handouts: |
in PDF
(released on Feb. 14)
|
Sample Solution: |
in PDF
(posted on Feb. 27)
|
|
Term Project (Phase 1, Data Manager)
|
|
Due Date (team formation): |
08:00pm, Thursday, Mar. 5, 2020
|
Due Date (Data Manager): |
08:00pm, Thursday, Mar. 26, 2020
|
Handout (Phase 1): |
in PDF
(released on Mar. 1)
|
github instructions: |
in PDF
(released on Mar. 1)
|
|
Assignment #5:
Query Processing & Optimization
|
|
Due Date: |
8:00 pm, Monday April 6, 2020
|
Handouts: |
in PDF
(released on Mar. 23)
|
Sample Solution: |
in PDF
(posted on Apr. 18)
|
|
Term Project (Phase 2, Scheduler & Transaction Manager)
|
|
Due Date: |
08:00pm, Thursday, Apr. 23, 2020
|
Handout (Phase 2): |
in PDF
(released on Mar. 26)
|
|
Term Paper (Final Exam)
|
|
Due Date: |
08:00pm, Saturday, Apr. 25, 2020
|
Handout: |
in PDF
(released on Apr. 1)
|