Answered step by step
Verified Expert Solution
Question
1 Approved Answer
c) For a rental property scenario, list all the functional dependencies. And normalize the following relation till 3NF for the rental property scenario. Cust# CName
c) For a rental property scenario, list all the functional dependencies. And normalize the following relation till 3NF for the rental property scenario. Cust# CName Prop# PAddr Rent StratDate RentEndDate Rent Owner# OName CR26 Ali Ahmed P4 House#9, Street 02/02/2018 01/02/2019 70000 POT Hamza Khan 20, F-11 P8 Majid Anwar CRIO Mehran Manzoor House! 1, Street 10, H-11 House#1, Street 2,1-11 P2 09/05/2017 10/02/2018 10/05/2018 09/02/2019 65000 50000 POS PO1 Hamza Khan Majid Anwar P3 19/05/2017 18/05/2018 45000 POS House#21, Street 4. G-11 Sara Kashif P5 28/09/2016 29/09/2017 25000 PO9 House#13, Street 5, G-9
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