Continue the process of normalizing the Client and PropertyRentalOwner 1NF relations shown to 3NF relations. At the end of this process check that the resultant 3NF relations are the same as those produce from the alternative ClientRental 1NF relation shown

What will be an ideal response?

The benefits of using the approach that creates two or more relations from the UNF table is
that some or all of the resulting tables may already be in 3NF. This is true for the Client table,
which is in 3NF. However, the PropertyRentalOwner table is only in 1NF due to the presence
of a partial dependency and a transitive dependency.
The PropertyRentalOwner relation is converted to 2NF with the removal of a partial
dependency. The result is creation of a new relation called PropertyOwner (2NF) and a
relation called Rental, which is in 3NF.
The PropertyOwner (2NF) relation is converted to 3NF with the removal of a transitive
dependency. The result is the creation of a new relation called PropertyForRent (3NF) and
Owner (3NF).
In summary, the process of normalizing the PropertyRentalOwner (1NF) relation resulted in
the creation of the Rental (3NF), PropertyForRent (3NF), and Owner (3NF) relations, which
together with the Client relation is the same four relations created from the ClientRental 1NF
relation shown