So i have a user table which has userId and schoolId which points to a userInstitution table consisting of userId and courseId. Pointing to the userInstitution table is the course table as well which consists of courseId and schoolId. 

user table --> userInstitution table <-- course table

I want to update a user to have a certain course assigned to them and i also want to know how i can select a user with a certain course.