Have a bit of confusion regarding a normalization from 1NF to BCNF. The teacher gave us this excercise to illustrate a normalisation all the way up to BCNF. I think I have found a problem with the given solution and would like to clear this up.
My understanding is that there are TWO partial dependencies here
The Primary key is made up of (SID, InstructorID)
- The Subject is dependent only on the the InstructorID and not on the entire primary key
- The Name is dependent only on the SID only and not on the entire primary key
Is my solution correct?
have I correctly performed the 2NF step?