Google News
logo
SQL Server - Interview Questions
Define the one-to-one relationship while designing tables.
One-to-One relationship : It can be implemented as a single table and rarely as two tables with primary and foreign key relationships.
 
One to one relationship exists if an entity in one table has a link with only one entity on another table. Let's take an example of the employee and their employee id so that a unique employee id will be there for a particular employee at another table.
Advertisement