Design Question
Date: Fri, 15 Oct 2004 21:57:40 GMT
Message-ID: <nJXbd.370887$mD.195310_at_attbi_s02>
Ok I've got a question on a database I am designing.
Here is some tables I have.
Contractors(contractorID,contractorsExtInfoID)
ContractorsExtInfo
(contractorsExtInfoID,contractorsLicenseInfoID,contractorsReferenceInfoID)
ContractorsLicenseInfo(contractorsLicenseInfoID,...)
ContractorsReferenceInfo(contractorsReferenceInfoID,...)
Ok all these tables are gonna have one to one relationships
I put a foreign key for the ContractorsExtInfo table in the Contractors table, then
I put the rest of the foreign keys in ContractorsExtInfo, I did this mostly
to keep the contractors table neater and also for more flexibilty, but...
Does this make any sense, and if it does then is doing it this way correct
or even ok?
I know I don't really need to but should I put a contractorID field in the
other tables, so I can relate back to the Contractors table?
Thanks Ray
Received on Fri Oct 15 2004 - 23:57:40 CEST