Normalise the following table named ‘GRADE’ to remove modification anomalies showing all steps for 1NF, 2NF and 3NF. State any necessary assumptions to support your answer.
Important : Provide appropriate justification for each normalisation step.
GRADE (sID, sLastName, sFirstName, sAddress, sState, courseID, courseName, creditPts, grade)
Primary Key: sID, courseID
Given that the following dependencies exist:
sID -> sLastName, sFirstName, sAddress, sState, courseID
courseID -> courseName, creditPts
sID, courseID -> grades