Given a positive integer N, the task is to find the number of relations that are irreflexive antisymmetric relations that can be formed over the… Read More

# Tag Archives: DBMS-Relational Algebra

Prerequisite – Relational Query Evaluation | Set 1 Data is stored in disks. Disks are then manipulated using read and write methods. More number of… Read More

There is a need for conversion of relational query to algebraic expressions. This expression is operated on so that final output is received. The relational… Read More

In clausal form, the formula is made up of a number of clauses, where each clause is composed of a number of literals connected by… Read More

Prerequisite – Relational Algebra 1. Selection : This operation chooses the subset of tuples from the relation that satisfies the given condition mentioned in the… Read More

Prerequisite – Relational Algebra We already are aware of the fact that relations are nothing but a set of tuples, and here we will have… Read More

Prerequisite – Relational Algebra Select operation chooses the subset of tuples from the relation that satisfies the given condition mentioned in the syntax of selection.… Read More

On modeling the design of the relational database we can put some restrictions like what values are allowed to be inserted in the relation, what… Read More

Prerequisite – Relational Algebra in DBMS These Set Theory operations are the standard mathematical operations on set. These operations are Binary operation that is, these… Read More

Both Relational Algebra and Relational Calculus are the formal query languages. Relational Algebra: Relational Algebra is a Procedural language. In Relational Algebra, The order is… Read More

Prerequisite – Keys in Relational Model A primary key is a column of table which uniquely identifies each tuple (row) in that table. Primary key enforces… Read More

A data store is basically a place for storing collections of data, such as a database, a file system or a directory. In Database system… Read More

In this article, Let’s discuss common types of questions in relational algebra which are asked in GATE. Before reading this article, you should have an… Read More

Basics of Relational model: Relational Model Relational Algebra is a procedural query language that takes relations as an input and returns relation as an output.… Read More

Basic idea about relational model and basic operators in Relational Algebra: Relational Model Basic Operators in Relational Algebra Extended operators are those operators which can… Read More