The following table is a non-normalized table for a Rental Property Management D
ID: 3911344 • Letter: T
Question
The following table is a non-normalized table for a Rental Property Management Database. Data is included to help you to perform the normalization. One client may have multiple rental records.
Identify the functional dependencies and normalize the table to 1NF, 2NF, and 3NF.
CLIENT_RENTAL
ClientNo
ClientName
PropertyNo
PropertyAddress
RentStart
RentEnd
RentFee
OwnerNo
OwnerName
CN12
John Smith
PN21
PN52
PN89
4 Market St. Bowie
12 S. Main St. Chevy Chase
4871 East St. Silver Spring
12/01/2006
07/01/2009
04/01/2008
6/30/2008
03/31/2011
500
750
900
ON68
ON77
ON120
Kent Shaw
Tina Short
Tim Johnson
CN18
Mary Helen
PN36
PN73
PN82
123 Ease St. Rockville
6528 Ohio Ave. Penn Park
21 West Point St. Bethesda
03/01/2005
03/01/2007
06/01/2012
02/28/2006
5/31/2010
12/31/2013
450
660
820
ON68
ON77
ON82
Kent Shaw
Tina Short
Steven Gates
CN20
Wendy King
PN66
2332 Main Street, Fulton
09/01/2014
780
ON10
Ben Johnson
ClientNo: Client Number (PK)
ClientName: Client (who rents a property) Name
PropertyNo: Property Number
PropertyAddress: Property Address (Do not need to break this attribute)
RentStart: Rent Start Date
RentEnd: Rent Ended Date
RentFee: Monthly Rental Fee
OwnerNo: Property Owner Number
OwnerName: Property Owner Name
Notes:
Can multiple clients rent the same property at the same time? For example, co-signers on a lease. No
Can one client rent multiple properties at the same time? I.e. if he rented a home and an office. Yes
Can one client rent the same property multiple consecutive times, requiring multiple records? For instance, he extends a lease for another year at a different rent. No
A property cannot have multiple owners.
The RentFee is not fixed for each property and can change from one Client to the next.
ClientNo
ClientName
PropertyNo
PropertyAddress
RentStart
RentEnd
RentFee
OwnerNo
OwnerName
CN12
John Smith
PN21
PN52
PN89
4 Market St. Bowie
12 S. Main St. Chevy Chase
4871 East St. Silver Spring
12/01/2006
07/01/2009
04/01/2008
6/30/2008
03/31/2011
500
750
900
ON68
ON77
ON120
Kent Shaw
Tina Short
Tim Johnson
CN18
Mary Helen
PN36
PN73
PN82
123 Ease St. Rockville
6528 Ohio Ave. Penn Park
21 West Point St. Bethesda
03/01/2005
03/01/2007
06/01/2012
02/28/2006
5/31/2010
12/31/2013
450
660
820
ON68
ON77
ON82
Kent Shaw
Tina Short
Steven Gates
CN20
Wendy King
PN66
2332 Main Street, Fulton
09/01/2014
780
ON10
Ben Johnson
Explanation / Answer
1NF
2NF
Functional Dependencies:
ClientNo -> ClientName
PropertyNo ->PropertyAddress,OwnerNo,RentStart,RentEnd
OwnerNo -> OwnerName
PropertNo,ClientNo -> RentFee
Tables in 2NF:
CLIENT
PROPERTY
OWNER
RENT
PN36
PN73
underlined attributes are primary keys and italicised are foreign keys. SOme attributes are both.
There is no transitive dependency , So all the tables in 2NF are also in 3NF.
Do ask if any doubt. Please upvote.
ClientNo ClientName PropertyNo PropertyAddress RentStart RentEnd RentFee OwnerNo OwnerName CN12 John Smith PN21 4 Market St. Bowie 12/01/2006 6/30/2008 500 ON68 Kent Shaw CN12 John Smith PN52 12 S. Main St. Chevy Chase 07/01/2009 03/31/2011 750 ON77 Tina Short CN12 John Smith PN89 4871 East St. Silver Spring 04/01/2008 900 ON120 Tim Johnson CN18 Mary Helen PN36 123 Ease St. Rockville 03/01/2005 02/28/2006 450 ON68 Kent Shaw CN18 Mary Helen PN73 6528 Ohio Ave. Penn Park 03/01/2007 5/31/2010 660 ON77 Tina Short CN18 Mary Helen PN82 21 West Point St. Bethesda 06/01/2012 12/31/2013 820 ON82 Steven Gates CN20 Wendy King PN66 2332 Main Street, Fulton 09/01/2014 780 ON10 Ben JohnsonRelated Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.