F-J-K
asked on
Simple Question about One-To-Many Relationship between Student and Country Tables - RDBMS SQL
I got Student table and Country table
Student {StudentID, Name, CountryID}
Country {CountryID, CountryName}
1. This means every student can have several countries while every country can not have several students! I do not get it. Does the above structure mean no two students can have same country name?
Student {StudentID, Name}
Country {CountryID, CountryName, StudentID}
Every country name can have several students a student can not have several countries. Can you explain please...
It's funny that it sounds simple but my mind does not seem having the sense of getting it...weird
Student {StudentID, Name, CountryID}
Country {CountryID, CountryName}
1. This means every student can have several countries while every country can not have several students! I do not get it. Does the above structure mean no two students can have same country name?
Student {StudentID, Name}
Country {CountryID, CountryName, StudentID}
Every country name can have several students a student can not have several countries. Can you explain please...
It's funny that it sounds simple but my mind does not seem having the sense of getting it...weird
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.
Thanks and glad to have helped.
ASKER
Thanks
ASKER