Question

Consider the following relation for rental clients: CLIENTRENTAL (clientNo, clientName, propertyNo, pAddress, rentStart, rentFinish, rentAmt, ownerNo, ownerName) The following functional dependencies exist: • clientNo --> clientName • propertyNo --> PAddress, ownerNo, ownerName • clientNo, propertyNo --> rentStart, rentFinish, rentAmt • ownerNo --> ownerName 2. Show step(s) to successively normalize it to 3NF. Be sure to use appropriate notations. (8 pts) From INF to 2NF (leave blank if not applicable)

Answer 1

CLIENTRENTAL C Client no , client Name, property No , p Address, rent start, rent finish, rentant, owner No owner Name). clientNo client Name property No p Address, owner No, owner Name. client No, property No * rentstart, rent finish, rentant owner No owner Name. because all attributes Above is in INF definately are atomic. Now check for 2NF.

A property NO from fos. there i key is (client No given. some partial dependencies. o client No → client Name © property No -> p Address, ownerno, owner Name (part of the key - Non-key INF to 2 NF Decomposing Above Relation CLIENT RENTAL, FDS No owner Name owner No oroner None Ri ( client No, client Name) | R2 (property No, pAddress, ownerne, owner Name) FOS clientNo client Name property → p Address, owner No, key client No >> No porotial dependeney key 쁘 is in 2NF. property No No transitive dependency so is in 3 NF. So is in 2NF. A transitive is there. owner No owner Name So it is not in 3NF. R3C client No, property No, rentStort, cent finish, rent Ant.) FDS client No, property No No rent stast, rentfinish, rent Ant I No porrtial dependency dependency key client No, property No ► no partial dependency.so in 2NE > No transitive dependency. so in 3NA

So only R₂ is not in 3NF Converting R2 from 2NF to BNF. fDS Decomposing R2 R4 Cproperty No, pAddress, owner no) Řg (owner No, Rg (owner No, owner Name) SDS property No sp Address owner No my owner Name properig Noy owner No. key 쁘 property No No partial dependeney No transitive dependeney Lo it r in BNF. owner No key 쁘 No porrtial dependency No transitive dependency it is in BNF. final de composed Relations in 3NF are R, ( client No, client Names FDS client Name clientNo IFDS R3 (client No, property No, reutstort, rent finish, rent Amt). client No, property No 5 tent stant, ventfinish, rent Amt. Ry (property No, pAddress, ownerno). Address, owner No R5 (owner No, owner Name) owner No e owner Name Р RDS property No FOS