Confused About One-to-Many Relationships - SQL Relational Database Managment System
1. Is it true that the table that carries the foreign key is considered the many side of the relationship? (Assume the table is called A)
2. I find that the table that has the foreign key always references back to the other table. In this case, table A references back to table B, so table B will have many tables points at it. Thus, table B is considered the "many" side of the relationship because it has many tables points at it. While 'A' table is considered the "one" side of the relationship because it can only points to one record in table B. Therefore, the statement in question 1 is false.
I'm quite confused about the whole concept little bit...
2. I find that the table that has the foreign key always references back to the other table. In this case, table A references back to table B, so table B will have many tables points at it. Thus, table B is considered the "many" side of the relationship because it has many tables points at it. While 'A' table is considered the "one" side of the relationship because it can only points to one record in table B. Therefore, the statement in question 1 is false.
I'm quite confused about the whole concept little bit...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have a look at the following:
http://www.tekstenuitleg.net/en/articles/software/database-design-tutorial/one-to-many.html
Good Luck!
Gary
http://www.tekstenuitleg.net/en/articles/software/database-design-tutorial/one-to-many.html
Good Luck!
Gary
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Well Answered
2. No, table B is the "one" side of the relationship.
Think of "one" and "many" not in terms of how many tables are pointing to a table, but like this...
"One" Customer can have "Many" Orders.
Or, one company can have many customers.
One order can have many items. Etc...