Relevance Of Unique Attribute In Many-To-One relationship
Joined: Apr 05, 2004
I was implementing a many-To-One relationship between 2 entities say A and B where A is on Many-Side i.e
So,that means many A can refer to the same B , so the rows of table A will have many similar values of 'id' on which it is joined with table B . But since we are refering the id column as unique that can't be possible , so this seems to be a contradictory to me or am i missing something ?
Thats what I was thinking , but here in my case the table A is joined with the primary key 'id' of table B and not vice-versa, so that is the only relationship defined and hence the table B can't have multiple instances of A.
So,if I am right if that is the case this many-to-one relationship is turned out to be one-to-one relationship.