Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Database Programming With Visual Basic.NET

Authors: Ying Bai

1st Edition

0521712351, 978-0521712354

More Books

Students also viewed these Databases questions

Question

Describe the factors influencing of performance appraisal.

Answered: 1 week ago

Question

a. Describe the encounter. What made it intercultural?

Answered: 1 week ago