Question :
Suppose you want to store the following information:
|
Student_id
|
Course
|
Mark
|
|
111
|
Maths
|
78
|
|
111
|
Physics
|
90
|
|
222
|
Biology
|
89
|
|
333
|
Physics
|
60
|
|
333
|
Chemistry
|
75
|
1.a Is this table in first normal form? Why or Why Not?
1.b Why it is not in 2NF? How you can change the above table into 2NF.