Consider this data Name Address City State Car Color Year Sm

Consider this data:

Name

Address

City

State

Car

Color

Year

Smith

123 4th Street

Pensacola

FL

Mazda

Blue

2012

Smith

123 4th Street

Pensacola

FL

Nissan

Red

2011

Jones

4 Moose Lane

Santa Clive

CA

Lexus

Red

2012

Katie

5 Rain Circle

Fort Walton

FL

Taurus

White

2012

And the following FDs:

Name Address, City, State, Car, Color, Year

Car Color, Year

Decompose as necessary to achieve 3NF.   

Solution

As we know for any table to be in 3NF it must not have any transistional functional dependency i.e., any non-prime attribute must not depend on any other non prime attribute... But here CIty depends upon Address and State also depends upon city and Address hence the above table to be in 3NF it must be reduced to

Table 1:

            Name,Address,Car

Table 2:

           Address,City,State

Table 3:

          Car,Color,Year

Hence the combination of these tables result in a 3NF satsfied table with the given all attributes...