a$)$ Using step$-$by$-$step process, normalize the above relation to BCNF$.$ Make sure you go through all

normalization steps from $1$NF to BCNF$.(30$ points$)$

Show your work. Your work must include the following:

i$.$ Indicate all anomalies lead to the violation of each normalization conditions.

ii$.$ List schemas for the final set of relations that are normalized to BCNF$.$ Make sure to

indicate all the primary, foreign, and surrogate keys $($if used$)$ in the final schemas.

iii. Indicate referential integrity constraint for the final set of schemas.