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
explain at least five widly used case tools

find the name of supplier who supply some red part

Describe the objective of Structural Diagrams The main objective of structural diagram is to visualize, construct, specify and document static aspects of a system. Their eleme

Which operation is used if we are interested in only certain columns of a table? PROJECTION operation is used if we are interested in only certain columns of a table.

Where does view definition stored? A view definition is permanently stored as part of the database.

why are older data models are being replaced by new data models

As with other software, databases can potentially be used for unethical purposes. As a database developer, and a consumer, you should recognize database misuse, and how it may affe

1.  Define each of the following IN YOUR OWN WORDS: (a)   File: (b)   Record: (c)   Field: (d)   Primary Key: (e)   Secondary Key: 2.  A travel agency wants t

losers with new information systems

Explain Domain calculus Domain calculus is one of the types of the relational calculus. The formal specification of the domain calculus was planned after the development of the