Q.A school having 500 students wants to identify beneficiaries of the merit-cum means scholarship, achieving more than 75% for two consecutive years and having family income less than 5 lakh per annum. Briefly describe data processing steps to be taken by the to beneficial prepare the list of school.

Relational Algebra Operations: A First Look

Think of a relational database as a collection of neat, rectangular tables. Each table has rows (records) and columns (attributes). Now, suppose you want to ask questions of this data — "Which customers live in Delhi?" or "Show me all orders placed last month." Relational algebra is the set of basic operations you use to answer such questions. It is the language of queries at the most fundamental level.

You do not need to write code or do math. You only need to understand what each operation does to a table — like a set of tools in a toolbox.

The Core Operations

There are eight classic operations. They fall into two groups: those that work on one table at a time, and those that combine two tables.

Operations on a Single Table

Select (also called Restrict) — This operation picks certain rows from a table based on a condition. For example, from a table of students, you might select only those rows where the city is "Mumbai". The result is a smaller table with the same columns but fewer rows.

Project — This operation picks certain columns from a table. For example, from a student table with columns Roll No, Name, City, and Marks, you might project only Name and City. The result is a table with fewer columns. Duplicate rows are automatically removed.

Rename — This operation simply gives a new name to the resulting table or to its columns. It is useful when you need to refer to the same table more than once in a query, or when you want clearer column headings.

Operations That Combine Two Tables

Union — This combines two tables that have the same structure (same number of columns and compatible data types). The result contains all rows that appear in either table, with duplicates removed. Think of it as "add the rows of one table to the rows of another, but keep only unique ones."

Set Difference — This gives you rows that are in the first table but not in the second. For example, "Which students are enrolled in Course A but not in Course B?"

Intersection — This gives you rows that appear in both tables. For example, "Which customers have bought both a laptop and a printer?"

Cartesian Product — This pairs every row of the first table with every row of the second table. If the first table has 10 rows and the second has 5, the result has 50 rows. This operation is rarely used alone — it is the foundation for the most powerful operation of all.

Join — This is the heart of relational algebra. A join combines rows from two tables based on a related column between them. For example, you have a Customers table and an Orders table. The join operation matches each order to the customer who placed it, using the Customer ID column that appears in both tables. The result is a single table with all the customer details alongside their orders.

Why Relational Algebra Matters

You will never write relational algebra directly in a real database system. Instead, you will use a language like SQL (Structured Query Language). But relational algebra is the underlying logic that every SQL query follows. When you write SELECT ... FROM ... WHERE ..., you are really performing a sequence of Select, Project, and Join operations behind the scenes.

Understanding relational algebra gives you a clear mental model of what a query actually does. It helps you reason about whether your query is correct, whether it will return the right rows, and how to break a complex question into simple steps.

A Simple Example to Fix the Idea

Imagine two tables:

Students — columns: Roll No, Name, City

Courses — columns: Course ID, Course Name, Roll No (the student enrolled)

You want: "Names of students from Delhi who are enrolled in the course 'Database'."

Here is how relational algebra would break it down:

1. Select from Students where City = "Delhi" → a temporary table of Delhi students.
2. Select from Courses where Course Name = "Database" → a temporary table of that course.
3. Join these two temporary tables on Roll No → a table with Delhi students enrolled in Database.
4. Project only the Name column → your final answer.

Each step is simple. Together they answer a meaningful question.

Relational algebra is not about computation. It is about thinking in tables — how to slice, combine, and reshape them to get the information you need. Once you see data as tables and queries as operations on those tables, the whole subject becomes intuitive.