Relational Algebra in DBMS

Selection

• The operation of choosing a subset of rows from a relation based on a specified condition.

• The process of combining two or more relations into a single relation.

• The method of removing duplicates from a relation.

• The technique of sorting rows in a relation based on a specific attribute.

Difference

• The operation that returns the rows in one relation that are not in another.

• The operation that combines rows from two relations based on a common attribute.

• The operation that retrieves all rows from two relations regardless of matching attributes.

• The operation that updates existing rows in a relation based on a condition.

Relation

• A type of database query that retrieves data from multiple tables.

• A table in a database that consists of rows and columns.

• A method for organizing data in a hierarchical structure.

• A software tool used for managing database transactions.

Union

• The operation that combines the results of two relations, including all unique rows.

• An operation that finds the intersection of two relations, including only common rows.

• A method to sort the results of two relations in ascending order.

• An operation that duplicates all rows from two relations.

Intersection

• The operation that returns only the rows that are common to two relations.

• The operation that combines all rows from two relations, including duplicates.

• The operation that returns all unique rows from two relations.

• The operation that removes duplicate rows from a single relation.

Projection

• The operation of choosing a subset of columns from a relation.

• The process of combining two relations into one.

• The method of filtering rows based on a condition.

• The technique of sorting data in ascending order.

Cartesian Product

• The operation that returns all possible pairs of rows from two relations.

• The operation that combines two relations into one by merging their columns.

• The operation that filters rows based on a specific condition.

• The operation that sorts rows in a relation based on a specified attribute.

Tuple

• A single row in a relation, representing a single record.

• A collection of multiple records in a database.

• A type of data structure that holds multiple values.

• A method for querying data from a database.

Attribute

• A row in a relation, representing a record of the data.

• A column in a relation, representing a property of the data.

• A type of database that stores data in tables.

• A function that retrieves data from a database.