What is recursive closure? Why is it not possible to describe this operation in relational algebra?

Recursive closure is applied to recursive relationship. An instance of recursive operation is to retrieve all SUPERVISEES of an Employee e at all levels- which is , all EMPLOYEE e directly supervised through e; all employees e" directly supervised through each employee e" and so on .

Posted Date: 5/11/2013 5:37:07 AM | Location : United States

Ask an Expert

Related Discussions:- What is recursive closure and operation relational algebra, Assignment Help, Ask Question on What is recursive closure and operation relational algebra, Get Answer, Expert's Help, What is recursive closure and operation relational algebra Discussions

Write discussion on What is recursive closure and operation relational algebra
Your posts are moderated

Write your message here..

Related Questions

What do you understand by raid, What do you understand by RAID? Explain RA... What do you understand by RAID? Explain RAID Level 4 and Level5? RAID - It is stands for Redundant Array of Inexpensive Disks (as named by the inventor), or alternatively Re

Object query language and odmg schema , (a)    Provide the description of t... (a)    Provide the description of the following ODMG schema in the Object Definition Language (ODL). (b)   Based on the above object database, write the following queries i

Using sql create a view rs for the relations r and s, Using SQL create a vi... Using SQL create a view RS for the relations R and S. The view consists of the columns A and D renamed as X and Y in that order. Insert a tuple into it. Show the contents of t

What are object interaction diagrams, What are object interaction diagrams?... What are object interaction diagrams? Object interaction diagrams are the diagrams that used to describe order in which messages are communicated in execution of an operation,

What are the advantages of object oriented databases, What are the advantag... What are the advantages of object oriented databases in comparison with others? Why it is still not widely used? Object oriented designs are coherent, efficient and less prone

Need customer management program, Project Description: This is a Custome... Project Description: This is a Customer Management project. Customer data is presented in a text file. The program can load this text data into its database columns. The data ma

Create a table for database transformation , Step 1 . Using Oracle, create ... Step 1 . Using Oracle, create the tables identified in the preferred solution for Assignment 2. Technicians (ZipCode, TechnicianID, FirstName, LastName, Street, City, State, Home

What is primary key, What is Primary key? Primary Key - Primary key i... What is Primary key? Primary Key - Primary key is one of the candidate keys which uniquely identifies each row in the relation.

Fragmentation, Differentiate between horizontal & mixed horizontal fragment... Differentiate between horizontal & mixed horizontal fragmentation?

Data files indices and data dictionary, The indices are accumulated in the ... The indices are accumulated in the index files. The data is accumulated in the data files. Indices give fast access to data items. For example, a book database may be managed in th