Question about E-R modelling

I've got the following business requirements for a scenario:

http://ompldr.org/vN2ZvdQ

and I came up with the following UML diagrams to model the relationship:

http://ompldr.org/vN2Y5Yg

I was wondering whether I have successfully managed to implement all the relations in the E-R model, especially the 1..* relationship. Furthermore, it is my understanding that mandatory relationships cannot be implemented just by using FK/PK so I开发者_运维百科 have to add additional constraints, is that so?

Its seems to be ok. You can use ERWin or DBDesigner to doing your work in a easier way. Consider ON DELETE CASCADE, ON UPDATE CASCADE, etc in your constraints.