RDBMS - Can't figure out where to place this table

Question

I've got a few days left before I need to hand in my relational database and everything's going alright. I have the database itself built but there's one design issue that I just can't figure out.

I need a results table, one that references the Members and the Competitions table but I already have a link table there. I'm pretty sure I've simply managed to mislead myself but hope you guys can help! :)

Since I'm an awkward 2 points away from being able to post an image, an imgur link to the schema itself is located here: https://i.stack.imgur.com/mNr0C.jpg

Answer 1

Looking at your tables, I think you are looking for either

1. joining Members-Competitions to Competitions-Prizes, which would give the explicit relationship between the member and the prize that they won in that competition, (This is creating a Members-Competitions-Prizes "link" or relation)

or

2. adding an attribute to the Members-Competitions relation that would show that members placement in the competition regardless of whether they won a prize. (This is creating a new column in the Members-Competition link/relation)

You choice will depend on what you expect to do with the information.