2. Given the following table, key and FDs,

REPAIR (RepairInvoiceNumber, RepairDate, RepairCost, RepairEmployeeName, RepairEmployeePhone, SerialNumber, Type, TankCapacity)

Candidate Keys:

RepairInvoiceNumber, and (RepairDate, SerialNumber)

Functional Dependencies:

RepairInvoiceNumber all other attributes

(RepairDate, SerialNumber) all other attributes

SerialNumber Type, TankCapacity

RepairEmployeeName RepairEmployeePhone

a) What normal form this table is in ? Why?

b) How do you normalize it. What normal form is each table in after you normalize the REPAIR table ? Indicate Keys and FKs