I need some help with this. I have been trying to figure out where to start.

 

NormalizationHere is some data that is to be kept in a database.Projects have multiple employees working on them.Pay rates are set by an employee’s job class.Normalize this data from unnormalized to 3NF.Explainwhat you are doing and why you are doing it at each step.Only do what is required from eachtransitions from one form to the next.Once you have explained a transition, show the new relations andtheir attributes.This can be of the form TABLE(A1, A2,..An).Make sure you have indicated keys wherenecessary by underlining them.This is sample data but does not represent all possibilities of data.Keep this in mind so you do not baseyour responses only on this dataset.

Attachments:

• 1493103957-Assignment 12 it.pdf