| Assignment #1:
Sample Submission
|
|
|
| Due Date: |
8:00 pm, Tuesday, Sept. 12, 2018 |
| Handout (HW1): |
in PDF
(released on Aug. 28)
|
|
| Assignment #2: Relational Model & Algebra
|
|
|
| Due Date: |
8:00pm, Wednesday, Sep. 19, 2018 |
| Handout (HW2): |
in PDF
(released on Sep. 10)
|
| Sample data: |
in TXT
(released on Sep. 10)
|
| Solution: |
in TXT
(posted on Sep 20)
|
|
| Assignment #3: Normalization
|
|
|
| Due Date: |
8:00pm, Wednesday, Sep. 26, 2018 |
| Handout (HW3): |
in PDF
(released on Sep. 20)
|
| Sample Solution: |
in
PDF
(posted on Sep. 27)
|
|
| Assignment #4: E-R Modeling
|
|
|
| Due Date: |
8:00pm, Wednesday, Oct. 3, 2018 |
| Handout (HW4): |
in PDF
(released on Sep. 27)
|
| Sample Solution: |
in
PDF
(posted on Oct. 8)
|
|
| Assignment #5: Relational Algebra & Basic SQL DML
|
|
|
| Due Date: |
8:00pm, Friday, Oct. 19, 2018 |
| Handout (HW5): |
in PDF
(released on Oct. 10)
|
| Supplemental RA Tool: |
in PDF
(released on Oct. 10)
|
| RA Forest Sample Database: |
in TXT
(released on Oct. 10, New version on Oct. 16 )
|
| Sample Solution: |
in
PDF
(posted on Oct 21)
|
|
| Assignment #6: SQL Nesting, Triggers, Transactions
|
|
|
| Due Date: |
8:00pm, Wednesday, Nov. 7, 2018 |
| Handout (HW6): |
in PDF
(released on Oct. 29)
|
| HW6 Database: |
hw6-db.sql
(released on Oct. 29)
|
| Sample Solution: |
hw6-sol-query.sql
(posted on Nov. 10)
|
|
|
Term Project
|
|
|
| Due Date (team formation): |
8:00pm, Tuesday, Nov. 6, 2018
|
| Due Date (Phase 1, DB Schema & SQL Statements): |
8:00pm, Monday, Nov. 19, 2018
|
| Due Date (Phase 2, Java code & Transactions): |
8:00pm, Monday, Dec. 3, 2018
|
| Due Date (Phase 3, Complete Project & Drivers): |
8:00pm, Sunday, Dec. 9, 2018 <--- New Date
|
| Handout: |
in PDF
(released on Nov. 1)
|
| github instructions: |
in PDF
(released on Nov. 1)
|
|
| Assignment #7:
Indexing and Concurrency Comntrol
|
|
|
| Due Date: |
8:00pm, Saturday, Dec. 8, 2018 |
| Handout (HW7): |
in PDF
(released on Nov. 29)
|
| Sample solution: |
in PDF,
(released on Dec. 9)
|
|
