Difference between one to one and one and only one relationship in SQL Server

Hi siddangoud,

If one department can have one employee then, department to employee is a one to one relationship, while if one department can have multiple employees then, department to employee is a one to many relationship.

Thats means table has one row that is associated with one row in another table.