|
| Assignment #1:
Sample Submission
|
|
|
| Due Date: |
8:00 pm, Wednesday, Jan. 24, 2018 |
| Handout (HW1): |
in PDF
(released on Jan. 19)
|
|
| Assignment #2: Relational Model & SQL DDL
|
|
|
| Due Date: |
8:00pm, Wednesday, Jan. 31, 2018 |
| Handout (HW2): |
in PDF
(released on Jan. 24)
|
| Sample data: |
in Plain text -- Good Data
and
Bad Data
(released on Jan. 24)
|
| Sample Solution: |
in hw2-design (PDF) and
hw2-db (TXT)
(posted on TBD)
|
|
| Assignment #3: Normalization
|
|
|
| Due Date: |
8:00pm, Thursday, Feb. 8, 2018 |
| Handout (HW3): |
in PDF
(released on Feb. 1)
|
| Sample Solution: |
in
PDF
(posted on Feb. 10)
|
|
| Assignment #4: E-R Modeling
|
|
|
| Due Date: |
8:00pm, Saturday, Feb. 17, 2018 |
| Handout (HW4): |
in PDF
(released on Feb. 10)
|
| Sample Solution: |
in
PDF
(posted on Feb. 27)
|
|
| Assignment #5: Relational Algebra
|
|
|
| Due Date: |
8:00pm, Monday, Feb. 26, 2018 |
| Handout (HW5): |
in PDF
(released on Feb. 20)
|
| Supplemental RA Tool: |
in PDF
(released on Feb. 22)
|
| RA Forest Sample Database: |
in BINARY
(released on Feb. 22)
|
| Sample Solution: |
in
PDF
(posted on Feb 27)
|
|
| Assignment #6: SQL
|
|
|
| Due Date: |
8:00pm, Tuesday, Mar. 20, 2018 |
| Handout (HW6): |
in PDF
(released on Mar. 14)
|
| Extra files: |
hw6-sample-data.txt, hw2-sol-db.sql
(released on Mar. 14)
|
| Sample Solution: |
hw6-sol-db.sql,
hw6-sol-query.sql
(posted on Apr 12)
|
|
| Assignment #7: Advanced SQL
|
|
|
| Due Date: |
8:00pm, Monday, Apr. 2, 2018 |
| Handout (HW7): |
in PDF
(released on Mar. 27)
|
| Extra files: |
hw7-db.sql,
extra-data.sql
(released on Mar. 27)
|
| Sample Solution: |
in
SQL
(posted on Apr 12)
|
|
| Assignment #8: Integrity Constraints, Transaction and Indexing
|
|
|
| Due Date: |
8:00pm, Tuesday, Apr. 17, 2018 |
| Handout (HW8): |
in PDF
(released on Apr. 3)
|
| Extra files: |
hw8-db.sql,
(released on Apr. 3)
|
| Sample solution: |
hw8-sol.pdf,
hw8-sol-db.sql,
hw8-sol-query.sql,
(released on Apr. 22)
|
|
