Due: Wednesday, July 8

Please upload your solutions to CSNS. Note that file uploading will be disabled automatically after 11:59PM of the due date, so please turn in your work on time.

Complete Exercise 3.23 and 3.24 in the textbook. For each exercise:

• (20pt) Create an ER diagram of the database design.
• (15pt) Convert the ER diagram to a relational schema.
• (15pt) For each table in the relational schema, list the functional dependencies and determine whether the table is in BCNF or 3NF.