Implementing one-to-zero-or-one relation in SQL Server

by

The 1-0..1 relation in your database is directly visible. It is built between Course and OnlineCourse tables where Course is principal in relation (1) and OnlineCourse is dependent with FK configured on CourseID. FK is also PK of the OnlineCourse = it must be unique and because of that it is 0..1.

Database “always” uses 1 – 0..1 because real 1 – 1 cannot be effectively used for data insertion. 1 – 1 means that left must be inserted after right but right must be inserted after left = impossible. Because of that 1 – 0..1 is used where left is principal and must be inserted before right and right is dependent and must be inserted after left.

More Related Contents:

  1. If condition in SQL Server 2008
  2. Comma separated results in SQL
  3. Understanding PIVOT function in T-SQL
  4. Which are more performant, CTE or temporary tables?
  5. Using RegEx in SQL Server
  6. Import Excel spreadsheet columns into SQL Server database
  7. SqlServer: Login failed for user
  8. INSERT INTO vs SELECT INTO
  9. SQL Server 2008 Empty String vs. Space
  10. How do I use the CONCAT function in SQL Server 2008 R2?
  11. How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
  12. Is it possible to force row level locking in SQL Server?
  13. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  14. How do I get date/time information from a TIMESTAMP column?
  15. How to drop column with constraint?
  16. SQL Server: combining multiple rows into one row
  17. How to add xml encoding to xml Output in SQL Server
  18. SQL Server GUID sort algorithm. Why?
  19. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  20. Sort Bullets in Database
  21. Unable to login to SQL Server + SQL Server Authentication + Error: 18456
  22. What’s the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?
  23. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  24. “Prevent saving changes that require the table to be re-created” negative effects
  25. How to change column datatype in SQL Server database without losing data?
  26. ‘Incorrect SET Options’ Error When Building Database Project
  27. Table Valued Function Killing My Query Performance
  28. How to convert text column to datetime in SQL
  29. Why insert-select to variable table from XML variable so slow?
  30. Generate MD5 hash string with T-SQL

Leave a Comment