Green Car Repair keeps track of data about customers, customers insurance, technicians, and repair jobs. The attributes and functional dependencies at Green Car Repair are assumed as follows.

Attributes

TechnicianID

TechnicianName

TechnicianTelephone

CustomerID

CustomerName

RepairType

RepairDate

RepairCost

InsuranceName

Functional Dependencies

TechnicianID TechnicianName

TechnicianID TechnicianTelephone

CustomerID CustomerName

CustomerID InsuranceName

TechnicianID+CustomerID+RepairDate RepairType

RepairType RepairCost

For For each of the following tables (they are independent case),

(1) write the tables current normal form (as 1NF, 2NF, or 3NF), and explain why;

(2) for each table that is currently in 1NF or 2NF, convert it into 3NF.

Primary key attributes are marked with *. Combination keys are grouped by using [...+...].

Do not assume any functional dependencies other than those shown above. (8 points)

A) [*TechnicianID+*CustomerID+*RepairDate], RepairType, RepairCost (2.2 points)

B) [*TechnicianID+*CustomerID+*RepairDate], CustomerName, InsuranceName, RepairType (2.7 points)

C) [*TechnicianID+*CustomerID+*RepairDate], TechnicianName, InsuranceName, RepairType, RepairCost (3.1 points)