Hey there! Sign in to join this conversationNew here? Join for free
x Turn on thread page Beta
    • Thread Starter

    Hey, I need some help designing a database for a cub group. I have a Cubs Table (Names of all the cubs details etc), A Badges table (all the awards they can achieve) and a Events table (such as camps). I need to draw a Entity Relationship diagram to link the tables together- i'm a bit confused because i'm unsure whether they are all many to many relationships and if so do i need another table in between? or is it okay:L?

    You cant have many to many relationships, so yes you do need a linking tables. These don't have to be proper entities however they can just be cubs/badges for example to link cubs and badges.
How are you feeling about your exams?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.