Question $1$: $(10$ points$)$

Source: Connolly and Begg

Students can lease university flats and some of the details of leases held by students for places in university flats are shown in relation snapshot below. A place number $($placeNo$)$ uniquely identifies each single room in all flats and is used when leasing a room to a student.

$($a$)$ Identify the functional dependencies that exist between the columns of the table in Figure $14\mathrm{.}23$ and identify the primary key and any other candidate key$($s$)($if present$)$ for the table.

$($b$)$ The relation shown in the figure is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table.

$($c$)$ Describe why the table in the figure is not in $3$NF$.$ List all violations on $3$NF$.$

$\backslash$table$[[$leaseNo$,$bannerID,placeNo,fName,IName,startDate,finishDate,flatNo,flatAddress$],[10003,$B$017706,78,$Jane,Watt,$\frac{01}{09}\frac{?}{2010},\frac{30}{06}\frac{?}{2011},$F$56,34$ High Street, Paisley$],[10259,$B$017706,88,$Jane,Watt,$\frac{01}{09}\frac{?}{2011},\frac{30}{06}\frac{?}{2012},$F$78,111$ Storrie Road, Paisley$],[10364,$B$013399,89,$Tom,Jones,$\frac{01}{09}\frac{?}{2011},\frac{30}{06}\frac{?}{2012},$F$78,111$ Storrie Road, Paisley$],[10566,$B$012124,102,$Karen,Black,$\frac{01}{09}\frac{?}{2011},\frac{30}{06}\frac{?}{2012},$F$79,120$ Lady Lane, Paisley$],[11067,$B$034511,88,$Steven,Smith,$\frac{01}{09}\frac{?}{2012},\frac{30}{06}\frac{?}{2013},$F$78,111$ Storrie Road, Paisley$],[11169,$B$013399,78,$Tom,Jones,$\frac{01}{09}\frac{?}{2012},\frac{30}{06}\frac{?}{2013},$F$56,34$ High Street, Paisley$]]$

Question $2$: $(5$ points$)$

Consider a Relation $R3=(A,B,C,D,E,F)$ which has the following functional dependencies:

$ABC$

$CDE$

$CD$

$BF$

Which of the following must also hold: