Question $1$:

Course$\_$Offering $($Course$\_$code, Section$\_$no$,$ Semester, Course$\_$title, Department, Credits,

Coordinator$\_$initial, Coordinator$\_$name, Coordinator$\_$email, Slot, Room$\_$no$,$ Building$\_$no$,$

Capacity, Total$\_$students$)$

The primary key of the relation is underlined. The relation has the following additional

functional dependencies $($FDs$)$:

FD$1$: Course$\_$code $$ Department, Credits, Course$\_$title

FD$2$: Course$\_$code, Semester $$ Coordinator$\_$initial, Coordinator$\_$name, Coordinator$\_$email

FD$3$: Coordinator$\_$initial $$ Coordinator$\_$Name, Coordinator$\_$email

FD$4$: Building$\_$no$,$ Room$\_$no $$ Capacity

a$.$ Explain if the above relation is in the first normal form $(1$NF$)$ or not? If not, apply $1$NF

normalization.

b$.$ Explain if the relation$($s$)$ of no $($a$)$ is$/$are in the second normal form $(2$NF$)$ or not? If not,

apply $2$ NF normalization.

c$.$ Explain if the relation$($s$)$ of no $($b$)$ is$/$are in the third normal form $(3$NF$)$ or not? If not,

apply $3$ NF normalization.