Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

  

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

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

Oracle 12c SQL

Authors: Joan Casteel

3rd edition

1305251032, 978-1305251038

More Books

Students also viewed these Databases questions

Question

Write a paper about medication error system 2016.

Answered: 1 week ago

Question

What is the purpose of the SELECT statement?

Answered: 1 week ago