Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 |
PLEASE NORMALIZE ABOVE TABLE UPTO 3NF. ALSO SHOW FUNCTIONAL DEPENDECIES AS (SNAME --> SADDRESS)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started