Relational Algebra Purpose The purpose of this assignment is to help you learn m
ID: 3604728 • 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 and discuss it with your friends.
All students have to participate at least 3 times in the discussions.
Submission Instructions
Post your ideas and responses on the discussion board. At least one original posting and two responses are mandatory
Explanation / Answer
This query will display the records of all employees from Employees table whose salary is greater than $4000.
Projection is used to display the attributes(columns) of the relations with or without condition.
This query will display only the attributes empname and salary of all employees.