The following INSTRUCTOR relation shows the information of instructors and the training sessions they offer. Each instructor can give any session at a chosen date. Why INSTRUCTOR relation is not in 2NF? How can you convert it be in 2NF?
Instructor_ID
InstructorName
SessionID
Session_Date
1
Ahmad
S1
June 1st
S2
July 1st
2
Ali
3
Mohammad
S3
August 15th
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here