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?
x Turn on thread page Beta
Entity Relationship Diagram Help watch
- Thread Starter
- 07-04-2013 15:18
- 08-04-2013 20:08
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.