Company X leases houses to clients. The administration keeps track of the lease activities using the spreadsheet below: ClientNo ClientName PropertyNo PropertyAddress Rentstart RentPinish Rent Owner No OwnerName CR76 6 Lawrence St., 17/1/2012 Glasgow Tina Murphy John Kay PG 4 | 8/31/2013 | 350 |CO40 5 Novar Dr.. Glasgow 6 Lawrence St.. 9/1/2011 10/10/2012 350 C40 Glasgow PG16 Tony Shaw Tina Murphy 9/1/20139/1/2014 450 Co93 Aline Stewart CR56 PG4 2 Manor Rd., 1 Tony shaw 5 Novar Dr., 11/1/2014 8/10/2015 450 co93 Tony ha PG36 0/10/2012 12/1/2013 375co93 Glasgow PG16 Glaagow c) Please illustrate how you would normalize this relation to Second Normal Form (2NF). What type of functional dependency iss) do you need to identify to convert this relation to 2NF? Please make sure to illustrate the tables.(40 pts Please convert the 2NF form you have achieved in section c to Thard Normal Form (3NF) Please make sure to illustrate the tables. What type of functional dependency(ies) do you need to identify to convert this relation to 3NF? (40 pts) d)