mysqlsqlschemardbmsargouml

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

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.sstatic.net/mNr0C.jpg

enter image description here

Solution

  • 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

    1. 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.