BITS wants to store information about the supervisors, including their supervisor number and the relationship to consultants. Supervisors can work with multiple consultants, but consultants only have one supervisor. In addition, supervisors specialize in working with clients in specific task categories. Using this information, convert the following unnormalized relation to fourth normal form:

Details

The unnormalized Consultant table that has to be converted to a fouth normal form. Consultant left parenthesis C o n s l t N u m$,$ Last Name, First Name, Street, City, Zip Code, Hours, Rate, left parenthesis Supervisor N u m$,$ Supervisor Name right parenthesis, left parenthesis Tasks, Description, Category, Price, Supervisor N u m right parenthesis right parenthesis. C o n s l t N u m is the primary key.