Re: Nested Sets vs. Nested Intervals

From: Mikito Harakiri <mikharakiri_nospaum_at_yahoo.com>
Date: 10 Nov 2005 16:39:36 -0800
Message-ID: <1131669576.263506.34580_at_g44g2000cwa.googlegroups.com>


amado.alves_at_netcabo.pt wrote:
> Each single concept is represented by a vertex. The properties of the
> concept are represented by topologies involving the vertex. The fact
> that employee x10 works in the accounting department may be modelled as
>
> Employees => x10
> x10 => x11
> WorksIn => x11
> x11 => Accounting
>
> where x => y means connected from x to y.

Before going to queries, could you please work out, that is demontrate what the graph is for the following two relations

Employees
Name Dept Salary
------ ------ -------

Smith 1       1000
Scott 2       2000
King 2       3000

Departments
Deptno Name
------ ------

1      Accounting
2      Manufacturing
Received on Fri Nov 11 2005 - 01:39:36 CET

Original text of this message