CREATE TABLE Marriage
(
-- Marriage is by husband-Person and Person has family-Name, HusbandFamilyName varchar NOT NULL, -- Marriage is by husband-Person and Person has given-Name, HusbandGivenName varchar NOT NULL, -- Marriage is of wife-Person and Person has family-Name, WifeFamilyName varchar NOT NULL, -- Marriage is of wife-Person and Person has given-Name, WifeGivenName varchar NOT NULL, PRIMARY KEY(HusbandGivenName, HusbandFamilyName, WifeGivenName, WifeFamilyName)
) GO
CREATE TABLE Person (
-- Person has family-Name, FamilyName varchar NOT NULL, -- Person has given-Name, GivenName varchar NOT NULL, PRIMARY KEY(GivenName, FamilyName)
) GO
ALTER TABLE Marriage
ADD FOREIGN KEY (HusbandGivenName, HusbandFamilyName) REFERENCES Person (GivenName, FamilyName)
GO
ALTER TABLE Marriage
ADD FOREIGN KEY (WifeGivenName, WifeFamilyName) REFERENCES Person (GivenName, FamilyName)
GO