Assignment 2 (3.3-3.5 Normalization)

American Fork Auto Sales Normalization

After meeting with Lewis, you design a first draft of the relations for a database to meet his need. You have added a few fields that you think will be helpful to him moving forward. The draft of relations is below. After reviewing your draft, you realize that the relations are not in third normal form.

Salesperson (SalesID, Name, Salary, Phone, StreetAddress, City, State, ZipCode)

Customer (CustomerID, Name, Phone, Income, CreditScore, CreditLevel, Street Address, City, State, ZipCode)

Encounter(ID, SalesID, CustomerID, Date, CustomerCreditLevel)

Foreign Key: SalesID references Salesperson

Foreign Key: CustomerID references Customer

Car (VIN, Make, Model, Year, Color, Price)