Page 4 > of 5 5 - ZOOM Part 3 - Normalization (20 marks total] Case 1: The table below lists student/University flat lea

[answerhappygod]

Page 4 Of 5 5 Zoom Part 3 Normalization 20 Marks Total Case 1 The Table Below Lists Student University Flat Lea 1 (129.41 KiB) Viewed 56 times

Page 4 > of 5 5 - ZOOM Part 3 - Normalization (20 marks total] Case 1: The table below lists student/University flat leases data. Student can lease university flats and some of the details of leases held by students for places in university flats are shown below. A place number (PlaceNo) uniquely identifies each single room in all flats and is used when leasing a room to a student LeaseNo Studentin PlaceNo FName LName StartDate EndDate Flat No FlatAddress 10003 S107706 78 Jane Watt 1/9/2020 30/6/2021 F56 34 High St Parramata 10259 S107706 88 Jane Watt 1/9/2021 30/06/2022 F78 111 Stump Rd, Parramata 10364 S013399 89 Tom Jones 1/9/2021 30/06/2022 F78 111Stump Rd, Parramata 10566 S012124 102 Karen Black 1/9/2021 30/06/2022 F79 130 Lady Lane, Parramata 11067 SO34511 88 Steven Smith 1/9/2022 30/06/2023 F78 111Stump Rd, Parramata 11169 S013399 78 Tom Jones 1/9/2022 30/06/2023F56 34 High St Parramata 1. The data in the table is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table, [3 marks) 2. Here are the functional dependencies represented by the data shown in the table above. FD1 LeaseNo → StudentiD, PlaceNo, FName, LName, StartDate, EndDate, Flatno, FlatAddress FD2 StudentiD FName, LName FD3 Flat No FlatAddress FD4 FName, LName → Studentin , Use this information to convert the above table into 3NF. You need to describe and show the steps of normalisation. Note: Currently the table is in INF. (5 marks)