Re: How to represent a total-and-exclusive relation into a relational database

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Jan 2005 12:36:39 -0800
Message-ID: <1106166999.904249.189350_at_z14g2000cwz.googlegroups.com>

Mathieu, Celko created the UK on the PK + another attribute, in this case, vehicle_type because his design calls for creating a table for each vehicle type and he want a FK from the vehicle type tables back to the parent for referential integrity.

HTH -- Mark D Powell -- Received on Wed Jan 19 2005 - 21:36:39 CET

This message: [ Message body ]
Next message: Anne & Lynn Wheeler: "Re: Foreign key in Oracle Sql"
Previous message: ak_tiredofspam_at_yahoo.com: "Re: Foreign key in Oracle Sql"
In reply to: Mathieu Pagé: "Re: How to represent a total-and-exclusive relation into a relational database"
Next in thread: -CELKO-: "Re: How to represent a total-and-exclusive relation into a relational database"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message