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 This is the same as graph above. But just the typed out version

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/2013	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 for reference:

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 CN12 RentStart RentEnd RentFee OwnerNo OwnerName ON68 ON77 ON120 John Smith PN21 PN52 PN89 4 Market St. Bowie 12/01/2006 6/30/2008 500 07/01/2009 03/31/201 750 04/01/2013 Kent Shavw Tina Short Tim Johnson 12 S. Main St. Chevy Chase 900 4871 East St. Silver Sprin 123 Ease St. Rockville CN18 Mary Helen PN36 PN73 PN82 03/01/2005 02/28/2006 450 03/01/20075/31/2010 660 06/01/2012 12/31/2013 820 ON68 ON77 ON82 Kent Shaw Tina Short Steven Gates 6528 Ohio Ave. Penn Park 21 West Point St. Bethesda 2332 Main Street, Fulton 09/01/2014 CN20 Wendy Kin PN66 780 ON10 Ben Johnson