Part E $(15$ Marks$)$

The following table $($households$)$ is provided where the values represent the number of households

in a given year by income band.

a$.$ Is HOUSEHOLDS 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 all columns apart from household type and year are

values of the attribute Covid cases from the HOUSEHOLDS entity. Name and describe the

operation that you will perform and what will the new table look like. Do you need to

define any new keys?

$(5$ Marks$)$

c$.$ After transformation provide the SQL statement to calculate the difference between the

minimum and maximum cases for each household type and year. Can this query be

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