Assignment #1:
Sample Submission
|
|
Due Date: |
11:59 pm, Wednesday, January 24, 2018 |
Handout: |
in PDF
(released on Jan. 19)
|
|
Assignment #2: SQL
|
|
Due Date: |
11:59 pm, Tuesday February 6, 2018
|
Handouts: |
Assignment in PDF
(released on Jan. 24)
|
|
Starting with Oracle in SQL*PLUS and
Oracle Developer (PDF)
(released on Jan. 24)
|
Sample data: |
in plain text
(released on Feb. 28)
|
Sample Solution: |
part 1 (Schema) in Text,
part 2 (Queries) in Text
(released Feb 20)
|
|
Assignment #3: Theory of Recovery and Serializability
|
|
Due Date: |
11:59 pm, Friday February 16, 2018
|
Handouts: |
Assignment in PDF
(released on Feb. 9)
|
Sample Solution: |
in PDF
(released Feb 20)
|
|
Assignment #4: Physical Storage & Access Methods
|
|
Due Date: |
11:59 pm, Monday February 26, 2018
|
Handouts: |
Assignment in PDF
(released on Feb. 20)
|
Sample Solution: |
in PDF
(released Feb 27)
|
|
Assignment #5: Relational Algebra
|
|
Due Date: |
11:59pm, Wednesday, March 14, 2018 |
Handout (HW5): |
in PDF
(released on Feb. 28)
|
Supplemental RA Tool: |
in PDF
(released on Feb. 28)
|
RA Forest Sample Database: |
in BINARY
(released on Feb. 28)
|
Sample Solution: |
in
PDF
(posted on Mar 16)
|
|
Term Project
|
|
Due Date (team formation): |
11:59pm, Wednesday, Mar. 14, 2018
|
Due Date (Milestone 1, Design): |
11:59pm, Friday, Mar. 23, 2018
|
Due Date (Milestone 2, Data Manager): |
11:59pm, Wednesday, Apr. 4, 2018
|
Due Date (Milestone 3, Prototype): |
11:59pm, Wednesday, Apr. 25, 2018
|
Handout: |
in PDF
(released on Mar. 2)
|
github instructions: |
in PDF
(released on Mar. 3)
|
|
Assignment #6: Physical Storage & Access Methods
|
|
Due Date: |
11:59 pm, Wednesday Mar 28, 2018
|
Handouts: |
Assignment in PDF
(released on Mar. 17)
|
Sample Solution: |
in PDF
(released Apr. 12)
|
|