All assignments (homeworks and project) must be submitted electronically via the class homework submission site: Submission site

Assignment #1: Sample Submission
Due Date:	8:00 pm, Wednesday, Jan. 22, 2020
Handout (HW1):	in PDF   (released on Jan. 15)
Assignment #2: Relational Model & SQL DDL
Due Date:	8:00 pm, Wednesday, Jan. 29, 2020
Handout (HW2):	in PDF   (released on Jan. 24)
Sample data:	in plain text   (released on Jan. 24)
Solution (Relational Model):	in PDF   (posted on Feb. 4)
Solution (SQL DDL):	in TXT   (posted on Feb. 4)
Solution (SQL Insert):	in TXT   (posted on Feb. 4)
Assignment #3: Relational Algebra
Due Date:	8:00 pm, Wednesday, Feb. 5, 2020
Handout (HW3):	in PDF   (released on Jan. 30)
Sample Solution:	in PDF   (posted on Feb. 15) -- updated solution
Assignment #4: More Relational Algebra
Due Date:	8:00 pm, Wednesday, Feb. 12, 2020
Handout (HW4):	in PDF   (released on Feb. 6)
Sample Solution:	in PDF   (posted on Feb. 16)
Assignment #5: Basic SQL
Due Date:	8:00 pm, Wednesday, Feb. 19, 2020
Handout (HW5):	in PDF   (released on Feb. 13)
Solution (SQL DDL):	in TXT   (posted on Feb. 21)
Solution (SQL Queries):	in TXT   (posted on Feb. 21)
Assignment #6: More SQL & Views
Due Date:	8:00 pm, Thursday, Feb. 27, 2020
Handout (HW6):	in PDF   (released on Feb. 21)
Solution (SQL):	in TXT   (posted on Feb. 28) -- updated solution
Assignment #7: Transactions, Triggers, and Procedures
Due Date:	8:00 pm, Wednesday, Mar. 25, 2020
Handout (HW7):	in PDF   (released on Mar. 16)
Sample data (SQL):	in hw7-company-inserts.sql (TXT) &
	in hw7-q7-inserts.sql (TXT)   (released on Mar. 16)
Solution (SQL):	in TXT   (Apr. 18)
Assignment #8: Normalization
Due Date:	8:00 pm, Saturday, Apr. 3, 2020 -- New deadline
Handout (HW8):	in PDF   (released on Mar. 26)
Solution:	in PDF   (Apr. 18)
Assignment #9: E-R Model
Due Date:	8:00 pm, Monday, Apr. 13, 2020
Handout (HW9):	in PDF   (released on Apr. 5)
Solution:	in PDF   (Apr. 18)