TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Argyle Ghost
NA
5
2.9k
Designing a normalized Sql Table Structure
Jan 30 2011 11:09 AM
I have a column in one table that needs to be associated with two or more columns in another table. How do I do this and keep the database normalized. Example (Analogy for best representation):
two tables - one table "Questions" second table "NFL Teams"
Table Question has a column that asks a question such as name four teams that have not been to the superbowl?"
How can I relate the NFL Table (4 teams) to this question. because this question would have 4 foreign keys associated with it (Lions, packers, jets, giants - I made up the question and I know the answer is no way accurate, so lets not get in to football with this question, its just so you can understand what I am trying to accomplish :D)
How do I do this and keep the database relational and normalized without having one table that rules them all or have columns in a table like "team1", "team2", etc... because I know that is wrong as well.
Please help, its been bugging me for days.
Grazie,
The Argyle Ghost
Reply
Answers (
2
)
Compare values from two different database: MySQL and Oracle
Build script for the application database. in heidisql