$1.$A$.)(25$ POINTS$)$ Design a relational database schema for this database application. Show

all the functional dependencies that should hold among the attributes.

You can make assumptions for unspecified requirements. If you do so$,$ please explicitly state

what those assumptions are, and where exactly you used them in the design of your relational

database schema.

$1.$B$.)(25$ POINTS$)$ Normalize your relation schemas for the database that are each into $3$NF

or BCNF$,$ whichever is applicable. Specify the key attributes of each relation.

You can make assumptions for unspecified requirements. If you do so$,$ please explicitly state

what those assumptions are, and where exactly you used them in your normalization process.