Normalization Excercise Clarification 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.  

The way I have solved it up to 3NF is as follows:


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




Finally, 3NF where the transitive dependency has now been removed and refactored into it's own table.
No BCNF violations here!!!


QUESTION:

Is my solution correct? 

have I correctly performed the 2NF step?
So The question has been answered in great detail in chat by ypercubetm https://dba.stackexchange.com/users/993/ypercube%e1%b5%80%e1%b4%b9

The short anwer is yes the solution above is one possible correct solution

Many thanks to ypercubetm for taking the time breaking it down for me!