Confused About One-to-Many Relationships - SQL Relational Database Managment System
Posted on 2009-05-17
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...