Normalise the following table named ‘GRADE’ to remove modification anomalies showing all

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

Complete Answer:

Get Instant Help in Homework Asap
Get Instant Help in Homework Asap
Calculate your paper price
Pages (550 words)
Approximate price: -
Open chat
1
Hello 👋
Thank you for choosing our assignment help service!
How can I help you?