Is the table in 3NF? 
If not, explain why - (provide specific rationale, use field names and values in the table to demonstrate your understanding). Explain what normal form the table provided is in. Once you have determined the format for 3NF, provide the create table commands to create the tables as if you were to create the tables in SQLite or MS ACCESS

 

Transcribed Image Text:

CustID, Name, StAddr, City and DOB refer to the person who purchased the car CarVin# Year Manufacturer Sales Price CustID Iname fname StAddr 12345 2014 Ford 27,000 2. Smith John 67890 2015 Honda 20,000 1 Doe Jane 10293 2012 Ford 18,000 3 Babcock Sam 54322 2010 GM 15,000 4 Babcock Sarah 98989 2013 Hyundai 18,500 2 Smith John 76766 2009 Toyota 10,000 5 Smith John City DOB Jan-68 Feb-00 Mar-99 123 Main Fort Myers 999 South Orlando 555 North Miami 333 East Destin 123 Main Fort Myers 123 Main Fort Myers Sep-85 Jan-68 Jan-95 CustID, Name, StAddr, City and DOB refer to the person who purchased the car CarVin# Year Manufacturer Sales Price CustID Iname fname StAddr 12345 2014 Ford 27,000 2. Smith John 67890 2015 Honda 20,000 1 Doe Jane 10293 2012 Ford 18,000 3 Babcock Sam 54322 2010 GM 15,000 4 Babcock Sarah 98989 2013 Hyundai 18,500 2 Smith John 76766 2009 Toyota 10,000 5 Smith John City DOB Jan-68 Feb-00 Mar-99 123 Main Fort Myers 999 South Orlando 555 North Miami 333 East Destin 123 Main Fort Myers 123 Main Fort Myers Sep-85 Jan-68 Jan-95