Q$1[5$ Marks$]$: Normalize the following relation.

Show possible candidate$/$primary keys and the functional dependencies.

Explain the normal form in which the relation is currently in $($based on the sample data$).$

Show how do you break the relation to get $4$ th Normal Form.

Show the new relations obtained after normalization and underline the

candidate$/$primary key in each new relation.

Q$2$: Marks$]$:

Given a relation $R(P,Q,R,S,T)$ and Functional Dependency set $FD=\{PQR,ST\}.$ Answer

the following questions:

Find all candidate keys. Explain your answer

Identify the best normal form that $R$ satisfies $(1$NF$,2$NF$,3$NF$,$ or BCNF$).$ Explain your answer.

If the relation is not in BCNF$,$ decompose it until it becomes BCNF if possible.