Explore the concept of one-to-one relationships in database design and how they are implemented in SQL Server.