The attached file shows the design of a database ER model, I am working with a group to decide on the relational schema of the table but we are now at a crossroads as there are two differing opinions and neither party is will to budge.
I would be very grateful if someone would have a look at the attached document and tell me which of the two answers is closest to the correct one.
I will post the two different answers in second, Thank you for your help it is appreciated.