Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Nested Sets vs. Nested Intervals

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@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 Thu Nov 10 2005 - 18:39:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US