DATABASE NORMALIZATION (1NF, 2NF, AND 3NF) HELP NEEDED!!!

The attached table is a non-normalized table for a RENTAL PROPERTY MANAGEMENT DATABASE. The data is included to
help perform the normalization... I need help with identifying the functional dependencies and normalizing the table to 1NF, 2NF, and 3NF.

  

Transcribed Image Text:

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 CN12 ClientName John Smith PropertyNo PropertyAddress PN21 4 Market St. Bowie RentStart 12/01/2003 RentEnd 6/30/2005 RentFee 500 OwnerNo ON68 OwnerName Kent Shaw PN52 12 S. Main St. Chevy Chase 07/01/2005 03/31/2008 750 ON77 Tina Short PN89 CN18 Mary Helen PN36 4871 East St. Silver Spring 123 Ease St. Rockville 4/1/2008 03/01/2002 900 02/28/2003 450 ON120 ON68 Tim Johnson Kent Shaw PN73 6528 Ohio Ave. Penn Park 03/01/2004 5/31/2007 660 ON77 Tina Short PN82 21 West Point St. Bethesda CN20 Wendy King PN66 2332 Main Street, Fulton 06/01/2007 09/01/2011 12/31/2010 820 780 ON82 Steven Gates ON10 Ben Johnson ClientNo: Client Number (PK) Client Name: Client (who rents a property) Name PropertyNo: Property Number Property Address: 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 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 CN12 ClientName John Smith PropertyNo PropertyAddress PN21 4 Market St. Bowie RentStart 12/01/2003 RentEnd 6/30/2005 RentFee 500 OwnerNo ON68 OwnerName Kent Shaw PN52 12 S. Main St. Chevy Chase 07/01/2005 03/31/2008 750 ON77 Tina Short PN89 CN18 Mary Helen PN36 4871 East St. Silver Spring 123 Ease St. Rockville 4/1/2008 03/01/2002 900 02/28/2003 450 ON120 ON68 Tim Johnson Kent Shaw PN73 6528 Ohio Ave. Penn Park 03/01/2004 5/31/2007 660 ON77 Tina Short PN82 21 West Point St. Bethesda CN20 Wendy King PN66 2332 Main Street, Fulton 06/01/2007 09/01/2011 12/31/2010 820 780 ON82 Steven Gates ON10 Ben Johnson ClientNo: Client Number (PK) Client Name: Client (who rents a property) Name PropertyNo: Property Number Property Address: 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