Answer:
Convert the table into normalize form
Explanation:
Un normalized relation of the given schedule is as
Consultant ( ConsultNum, Last Name, First Name, Street, City, ZipCode
HoursRate (SupervisorNum, Supervisor Num)
(Tasks, Description, Catagory, Price, SupervisorNum))
According to these functional dependencies :
SupervisorNum is dependencies of the SupervisiorNum
ConsltNum is dependencies of the Last Name, First Name, Street, City, ZipCode, Hours, Rate
Tasks are dependencies of Description, Category, Price
The consultant table is not in a normalized form as it contains repeating groups. Make composite keys such as Supervisor Num, Tasks and ConsltNum and convert the table in NF by removing repeating groups
Such as table in NF
Consultant
(Consult Num, Last Name, First Name, Street, City, Zip Code, Hours, Rate
Supervisor Num, Supervisor Name, Tasks, Description, Category, Price)
