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

From: Mathieu Pagé <mathieu_dot_page_at_GoogleEmailSystem.com>
Date: Tue, 18 Jan 2005 13:38:25 -0500
Message-ID: <uIcHd.52889$%K3.1232946_at_weber.videotron.net>



Hi,

I have this conceptual model:

I have a type employe and each employe can be an InternEmploye or a Freelancer so I have a total-and-exclusive specialisation.

I would like to know how I should translate this into relational database tables.

if it were in a programming language like C++ it would be inheritance. How can I simul that in a relational database.

I hope my english is understandable,

Thanks in advance for your help

Mathieu Pagé
mathieu.page_at_Google's_Email_Service.com Received on Tue Jan 18 2005 - 19:38:25 CET

Original text of this message