Consider the following relation titled Excelsior Event Bookings shown below and answer the

questions:

EXCELSIOR EVENT BOOKINGS

The requirements for this table are as follows:

Each hall has a unique Hallld and HallSize.

Each client has a unique Clientld and ClientName

Each hall can have at most one event booked for it on one date

Clients can book more than one event with Excelsior Events

a$)(10$ points$)$ In the figure below, indicate all functional dependencies.

b$)(2$ point$)$ Using one sentence, describe a valid example of an insertion anomaly in the

EXCELSIOR EVENT BOOKINGSc$)(2$ point$)$ Using one sentence, describe a valid example of a deletion anomaly in the EXCELSIOR EVENT BOOKINGS

d$)(2$ point$)$ Using one sentence, describe a valid example of a modification anomaly in the EXCELSIOR EVENT BOOKINGS

e$)(8$ points$)$ Normalize the relation EXCELSIOR EVENT BOOKINGS to the second normal form $(2$NF$).$ Show column names $($underline primary keys$)$ and functional dependencies.

f$)(6$ points$)$ Normalize the relation EXCELSIOR EVENT BOOKINGS to the third normal form $(3$NF$).$ Show table names, column names $($underline primary keys$),$ and functional dependencies.