Relational algebra, Database Management System

 Relational Algebra is a set of basic operations used to influence the data in relational model. These operations allow the user to specify basic retrieval request. The result of retrieval is a new relation, produced from one or more relations. These operations can be divided  in two categories:

•  Basic Set Operations

1)  UNION

2)  SET DIFFERENCE

3)  INTERSECTION

4)  CARTESIAN PRODUCT

•  Relational Operations

1)   JOIN

2)  PROJECT

3) SELECT

4)  DIVISION

Posted Date: 3/6/2013 5:40:47 AM | Location : United States







Related Discussions:- Relational algebra, Assignment Help, Ask Question on Relational algebra, Get Answer, Expert's Help, Relational algebra Discussions

Write discussion on Relational algebra
Your posts are moderated
Related Questions
how to implement mid square hashing?

Structure Of Distributed Database: A distributed database system haves of a collection of sites, each of which keeps a local databases system. Every site is able to process local

Define about the Stored Procedure - It's a set of T-SQL statements combined together to perform a single task formed by combining numerous small tasks. - When you essentiall

What is the use of unique function? UNIQUE function: If UNIQUE is specified then only unique values are used to computed the mean.

The Structured Query Language INTRODUCTION Database is an organised set of information about an entity having controlled redundancy and serves numerous applications. DBMS

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 is an ER diagram? Why is it used in Database management system (DBMS)?

Describe the various types of Online Analytical Processing (OLAP) tools and briefly discuss how the support common analytical operations.

Explain query execution plan? - Optimizer available in SQL Server optimizes code to be effectively executed. - A query execution plan demonstrates how this optimizer would r

We need help in Booking System for Golf Business Development of a web based booking system which permits clients to book golf lessons with the following features- a) 4 user p