please answer the 5 questions

IMAM ABDULRAHMAN BIN FAISAL UNIVERSITY Practical Session Plan Sample data is taken from two leases for two different clients called John Kay and Aline Stewart and is transformed into table format with rows and columns, as shown in Figure 2. This is an example of an unnormalized table. Figure 2; CliontRental unnomalized tabie. Answer the following questions: Question 1: Put the unnormalized table in INF and explain the changes you made. Question 2: Choose the best selection of attribute(s) to perform as ClientRental primary key. Question 3: Identify all functional dependencies presented in 1NF ClientRental including: functional dependencies, transitive dependencies, multivalued dependencies, or join dependencies. Question 4: Draw 2NF relations derived ClientRental INF relation and explain the changes you made. Question 5: Draw 3NF relations derived from the previous step relations and explain the changes you made. [?] Outcome A: Solving Normalization exercises. 7- Tool(s)/ Software Microsoft Word A collection of (simplified) DreamHome leases is shown in Figure 1. The lease on top is for a client called John Kay who is leasing a property in Glasgow, which is owned by Tina Murphy. For this worked example, we assume that a client rents a given property only once and cannot rent more than one property at any one time. Figure 1: Collection of simplified DreamHouse leases