Riddle me this, batman.

Why do database designers deliberately create one-to-one relationships?

e.g. You can have a table with 50 columns, or you can have two tables with a one to one relationship, having 25 columns in one and 25 columns in the next (the foreign key acting as a primary key). Maybe the first column is called "Contact_Details" and the next table "Contact_Details_Extended"

What's the big advantage? Something tells me Frans Bouma might have an opinion on this. Anyone? Bueller? Bueller?

Any ideas? Leave a comment, or mail me.

My book "Choose Your First Product" is available now.

It gives you 4 easy steps to find and validate a humble product idea.

Learn more.