What is recursive closure and operation relational algebra, Database Management System

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







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
Related Questions
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

(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. 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? 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 in comparison with others? Why it is still not widely used? Object oriented designs are coherent, efficient and less prone

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

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? Primary Key - Primary key is one of the candidate keys which uniquely identifies each row in the relation.

Differentiate between horizontal & mixed horizontal fragmentation?

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