Understanding Table Relations
SQL server adds foreign keys to implement relations between tables in a relational database. A table can have one-to-one, one-to-many, or many-to-many relations with another table, depending upon the type of data you want to store.
A one-to-one relationship is simple and rarely used. Each record in a particular table relates to exactly one record in another table.Read More