- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Posted on 1/17/14 at 1:23 pm to Tortious
quote:
If someone is on two teams would you want the data in both team tables right?
Someone could theoretically be on a max of three competitive teams and could compete in a max of 5-6 competitions.
Posted on 1/17/14 at 1:30 pm to Tortious
quote:
I think your design maybe part of the problem. If someone is on two teams would you want the data in both team tables right?
Lets start with table design. In the simplest(it's normalized but simple) form what I would do is have four tables.
PKs are bold, FKs are Italics
Alumni
Al_ID, Name, Info Fields....
Alumni_team_xref
Al_ID, Team_ID
Team_Master
Team_ID, Desc_Fields...
Competitions
Comp_ID, Team_Id, Comp_date, Detail fields...
This post was edited on 1/17/14 at 1:41 pm
Popular
Back to top
Follow TigerDroppings for LSU Football News