PLEASE NORMALIZE ABOVE TABLE UPTO 3NF. ALSO SHOW FUNCTIONAL DEPENDECIES AS (SNAM

Question

PLEASE NORMALIZE ABOVE TABLE UPTO 3NF. ALSO SHOW FUNCTIONAL DEPENDECIES AS (SNAME --> SADDRESS)

clientNo propertyNo Cname paddress rentStart rentFinish rent ownerNo Oname CR76 PG4 JOHN KAY 6 LAWRENCE ST, GLASGOW 1-JUL-03 31-AUG-04 350 CO40 TINA MURPHY CR76 PG16 JOHN KAY 5 NOVAR DR, GLASGOW 1-SEP-04 1-SEP-05 450 CO93 TONY SHAW CR56 PG4 ALINE STEWART 6 LAWRENCE ST, GLASGOW 1-SEP-02 10-JUN-03 350 CO40 TINA MURPHY CR56 PG36 ALINE STEWART 2 MANOR RD, GLASGOW 10-OCT-03 1-DEC-04 375 CO93 TONY SHAW CR56 PG16 ALINE STEWART 5 NOVAR DR, GLASGOW 1-NOV-05 10-AUG-06 450 CO93 TONY SHAW

Explanation / Answer

Functional dependencies :

clientNo -> Cname

propertyNo -> paddress,rent

ownerNo -> Oname

clientNo,propertyNo,ownerNo -> rentStart,rentFinish

Tables in 3NF

CLIENT(clientNo ,Cname )

PROPERTY(propertyNo, paddress,rent)

OWNER(ownerNo,Oname)

RENTDATE(clientNo,propertyNo,ownerNo, rentStart,rentFinish)

underlined are primary keys and italicised are foreign keys. Some attributes are both.

Do ask if any doubt. Please upvote.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.