| 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)
|
