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.

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.

Question 1: Put the unnormalized table in 1NF 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 1NF relation and explain the changes you made.

Question 5: Draw 3NF relations derived from the previous step relations and explain the changes you made.