Relational Algebra Purpose The purpose of this assignment is to help you learn m
ID: 3595124 • Letter: R
Question
Relational Algebra
Purpose
The purpose of this assignment is to help you learn more about the relational algebra.
Brief Introduction
Relational Algebra Relational algebra is a procedural query language, which takes instances of relations as input and yields instances of relations as output. It uses operators to perform queries. An operator can be either unary or binary. They accept relations as their input and yield relations as their output..
Action Items
You are requested to submit one example of relational algebra
i need example without photos also in tables
Example:
Student
ID NAME AGE
1 ABC 5
2 CDE 10
3 FGH 15
Select rows that are greater than age 10, produces a new relation for only names
( (student) )
name age>10
new relation:
NAME
ABC
CDE
= selection
similer to this example the answer in the same way please
Explanation / Answer
Query to find the names of student whose age is less than or equal to 10
name ( age <= 10 (student) )
Output:
NAME
ABC
CDE
Another Example
Query to find the age of student whose name is ABC
age ( name = "ABC" (student) )