CODEWITHSUNDEEP
sqlsql-server
learningdb
learningdb

Reputation: 169

Is this a denormalized table?

I am not sure but is this a denormalized table?

EmployeesGrade
EmpID
Grade1
Grade2
Grade3

If yes, how do make this a normalized table?

Upvotes: 2

Views: 148

Answers (1)

John Pickup
John Pickup

Reputation: 5115

It appears to be denormalised. To normalise you would structure it as

EmpID
GradeNo
Grade

with EmpID and GradeNo as the primary key. Example records would then be:

EmpID   GradeNo Grade
-----   ------- -----
123     1       A
123     2       B
123     3       A
234     1       D
...

Upvotes: 5

Related Questions