Homework #3: Normalization

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.