Re: Database planning - Hierarchical problem - Help needed

From: Leandro Guimarães Faria Corsetti Dutra <leandro_at_dutra.fastmail.fm>
Date: Mon, 29 Nov 2004 21:25:18 +0200
Message-ID: <pan.2004.11.29.19.25.17.168233_at_dutra.fastmail.fm>


Em Mon, 29 Nov 2004 03:50:42 -0800, Philippe escreveu:

> All these links are work relationship between employees... So for example,
> Bert superior is Albert. And Chuck has two superiors : Albert and John

CREATE DOMAIN emp_id AS NUMBER;
CREATE TABLE organogram (manager emp_id, employee emp_id);

-- 
Leandro Guimarães Faria Corcete Dutra <leandro_at_dutra.fastmail.fm>
Maringá, PR, BRASIL                            +55 (44) 3025 6253
http://br.geocities.com./lgcdutra/             +55 (44) 8803 1729
Soli Deo Gloria!                               +55 (11) 9406 7191
Received on Mon Nov 29 2004 - 20:25:18 CET

Original text of this message