Students can lease university flats and some of the details of leases held by students for places in university flats are in following table. A place number (placeNo) uniquely identifies each single room in all flats and is used when leasing a room to a student.
Find out the functional dependency and determine the primary key. Why the table is not in 3NF. Convert the table into 3NF.
