To reiterate what everyone else is trying to tell you, we cannot help you unless you follow minimal forum rules and netiquette. We need to see DDL. This DDL should include keys (you do know the table has to have a key, do not you?), Constraints, DRI actions and all that stuff.

If you are working in a shop where people give you specs like this to program from, it is time to update your resume and leave your employer is both stupid and rude. He expect you to read his mind, which is clearly impossible.

I hope you understand about weak and strong entities and actually have a valid data model. Also, why do not you show us what you have tried instead of giving us a vague useless narrative? You did try something did you not? 😉