Q$\mathrm{.}2($a$)($b$)$ What is canonical cover of functional dependency'? Find the canonical cover by considering

the following set F of functional dependencies:

P$.-$ I A $--$ BC$,$ B $--.$ A$,$ C $--.-$ AB$,$ AB $---0$ C :

Elaborate the significance of using normalization in database system. Also, highlight the

differences between $3$NF and BCNF$.$ Consider a relation R $($A$,$B$,$C$,$D$,$E$)$ with flowing set of

functional dependencies as

$\{$BC$->$D$.$ AC$->$BE$,$ B$->$E$1$

Determine given relation R is in which normal form $($check up to $3$NF$)?$