Acme Truck Rentals
Maintenance Report
Truck VIN: 2389FHQ98H8Q8
Truck Type: Panel
Model Year: 2010
Make: Dodge
Color: Blue
Tag Number: 224658
Repair Date Repair Code Repair Type Hours spent
On repair Mileage Mechanic's ID Mechanic's Name
1/15/11 OC Oil Change 1 17,256 JS-004 Joshua Smith
2/28/11 OC Oil Change 1 21,055 AB-001 Arlie Brenner
4/12/11 RT Rotate Tires 2 25,778 TS-001 Theresa Stanley
4/12/11 OC Oil Change 1 25.778 JS-004 Joshua Smith
4/19/11 BO Brake Overhaul 5 27,552 PC-002 Peter Chandler
Go through the process of converting this user's view into 1NF, then 2NF and finally 3NF. Show and explain each step along the way.
Question 2
The following is a code for one product in an extensive cosmetic line: L02002Z621289. L means that it is a lipstick, 0 means it was introduced without matching nail polish, 2002 is a sequence code indicating in what order it was produced, Z is a classification code indicating that the product is hypoallergenic, and 621289 is the number of the plant (there are 15 plants) where the product is produced.
a. Critique the code, identifying the advantages and shortcomings of the scheme.
b. Always interested in new design, the owner of the cosmetic firm is willing to look at a more elegant code that encodes the same information in a better way. Redesign the coding scheme and provide a key for your work.
c. Write a sentence for each change you have suggested, indicating what data entry problem (from part a) the change will eliminate.