Not sure if it is okay to post this here, but if this is correct, it will help everyone understand better. OP could help verify.
http://mica.edu.vn/perso/kiendt/doc/EE4253-EE6133/Database%20Design,%20Application%20Development,%20and%20Administration.pdf
pages 365-367