When drawing DB relationship diagrams, do you usually show all the relationships? Because I seem to have lots of them and my diagram is geting very messy.
Sample Pic attached, I didnt even fill in all of them in this diagram
matale
3
Light Poster
Recommended Answers
Jump to PostNo, Not Always. If The Diagram Is Getting Messy, Then It Points Towards The Database Design Needing A Look At.
I've Checked Out The Sample Pic & My Thought Is That There's A Lot Of Pairings Of Player_ID & Team_ID. Maybe A Seperate Table With These Two In Would …
Jump to PostI Think The New Layout Is Better.
I Wouldn't Worry Too Much About An Extra Join In The SQL Query. So Long As The PKs Are Integers & You Use Clustered Indexes (Assuming You're Using SQL Server / Oracle...)
A Couple Of Other Ideas :
The YellowCards/RedCards …
All 6 Replies
SkinHead
2
Light Poster
matale
3
Light Poster
SkinHead
2
Light Poster
matale
3
Light Poster
patrinarobey
0
Newbie Poster
Leonarda
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.