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
You might also like to view...
What is the Work buffer? Name two ways of writing the contents of the Work buffer to the disk.
What will be an ideal response?
Which IE tab enables you to enter websites that you do not trust so they will be blocked?
A) Connections B) Programs C) General D) Content E) Security
Every time you open a database you will receive a security warning.
Answer the following statement true (T) or false (F)
Which of the following statements is NOT true about network standard
What will be an ideal response?