[dba-SQLServer] one to one

I'm guessing that you force a one-to-one in SQL Server the same way you do
in Access -- by setting a unique index on the foreign key? 
 
Is this correct?
 
Susan H.