| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Nested Sets vs. Nested Intervals
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 ManufacturingReceived on Thu Nov 10 2005 - 18:39:36 CST
![]() |
![]() |