- 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
re: Any Microsoft Access Experts?
Posted on 1/17/14 at 1:38 pm to TheOcean
Posted on 1/17/14 at 1:38 pm to TheOcean
quote:
I have a book and a shite ton of videos on database design. Unfortunately it's not very helpful, as you can tell.
This is a generic 'student athlete' database schema. This site has tons of example schemas for many situations.
Posted on 1/17/14 at 1:43 pm to Korkstand
Anddddd this is why I'm out this thread. I just realized my xref table had AL_ID as PK and Team_ID as FK.
Why didn't anyone catch that? DUHHHHH
Both fields are the PK aka candidate key in that table. it's a many to many relationship(remember cardinality, yall?) with alumni to teams. DOH! on my part.
But I fixed it so both fields are bolded.
I'm out before I take on this shite and don't spend rest of day in Weekend plans thread.
Why didn't anyone catch that? DUHHHHH
Both fields are the PK aka candidate key in that table. it's a many to many relationship(remember cardinality, yall?) with alumni to teams. DOH! on my part.
But I fixed it so both fields are bolded.
I'm out before I take on this shite and don't spend rest of day in Weekend plans thread.
This post was edited on 1/17/14 at 1:45 pm
Popular
Back to top
![logo](https://images.tigerdroppings.com/images/layout/TDIcon.jpg)