The following table $($TABLE$)$ is provided:

a$.$ Is TABLE normalized? if so$,$ in which normal form? Does it need to be transformed? Explain

your answer using functional dependencies.

$(5$ Marks$)$

b$.$ You are given the information that the values peek and show are attributes of the TABLE. Name

and describe the operation that you will perform and what the new table will look like.

$(5$ Marks$)$

c$.$ Provide the SQL statement to calculate the difference between peek and show. Can this query

be executed? If so$,$ explain why. Is there an alternative way without transformation?