1-1 relationships
From: Angus Monro <ajmonro_at_ingennia.com.au>
Date: Thu, 30 Nov 2000 15:33:37 +1100
Message-ID: <3A25D8A1.4A66819D_at_ingennia.com.au>
Date: Thu, 30 Nov 2000 15:33:37 +1100
Message-ID: <3A25D8A1.4A66819D_at_ingennia.com.au>
Given that two types of entities have a one-to-one relationship, are there any good reasons for mapping them to two distinct tables with appropriate foreign-key relationships, versus mapping them into a single table? The theoretical side of me wants to keep them in distinct tables, but I can't see the point of the extra space overhead and the time overhead incurred by needing to do joins betweeen them when querying.
Angus Monro. Received on Thu Nov 30 2000 - 05:33:37 CET