|
Assignment #1:
Sample Submission
|
|
Due date: |
8:00 pm, Wednesday, Sep. 15 |
Handout (HW1): |
in PDF
(released on Sep. 1)
|
|
Assignment #2:
Relational Model, Relational Algebra, and SQL (Group Assignment)
|
|
Due date: |
8:00 pm, Wednesday, Sep. 29 |
Handout (HW2): |
in PDF
(released on Sep. 15)
|
Insert statements: |
in SQL
(released on Sep. 15)
|
Relational algebra descriptions: |
in PDF
(released on Sep. 15)
|
Sample solution: |
hw2-RA-sol.pdf (released on Sep. 30)
hw2-db.sql (released on Sep. 30)
hw2-query.sql (released on Sep. 30)
|
|
Assignment #3:
Database Design (Group Assignment)
|
|
Due date: |
8:00 pm, Monday, Oct. 18 |
Handout (HW3): |
in PDF
(released on Sep. 30)
|
ER-to-Relational Mapping: |
in PDF
(released on Oct. 5)
|
Sample solution: |
hw3-sol.pdf (released on Oct. 18)
|
|
Assignment #4: Advanced SQL DML, Views, and Transactions (Group Assignment)
|
|
Due date: |
8:00 pm, Monday, Nov. 15 |
Handout (HW4): |
in PDF
(released on Nov. 2)
|
Database creation: |
in SQL
(released on Nov. 2)
|
Insert statements: |
in SQL
(released on Nov. 2)
|
Sample solution: |
hw4-db.sql (released on Nov. 18)
hw4-query.sql (released on Nov. 18)
|
|
Assignment #5: US Forest Registry System (Group Assignment)
|
|
Due date: |
8:00 pm, Monday, Dec. 6
Dec. 7 |
Handout (HW5): |
in PDF
(released on Nov. 18)
|
Sample solution for Proc., Func., and Triggers: |
hw5-sol.sql (released on Dec. 15)
|
|
Assignment #6: Concurrency Control & Access Methods (Group Assignment)
|
|
Due date: |
8:00 pm, Saturday, Dec. 11 |
Handout (HW6): |
in PDF
(released on Dec. 2)
|
Sample solution: |
hw6-sol.pdf (released on Dec. 12)
|