Welcome to your Relational Algebra
This Quiz is based on chapter four , MIST 320.
best wishes
Ahmed Farouk Ismail
Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
Which of the following is used to denote the selection operation in relational algebra?
For select operation the ________ appear in the subscript and the ___________ argument appears in the parenthesis after the sigma.
The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.
Which is a join condition contains an equality operator:
In precedence of set operators, the expression is evaluated from
Find the ID, name, dept name, salary for instructors whose salary is greater than $80,000
Find all students who have taken all courses offered in the Biology department.” The expressions that matches this sentence is :
A set of possible data values is called
When we want to display records with attributes from many relations then we use:
SELECT operator works _____ wise whereas PROJECT operator works _______ wise.
The relational operator -------------, also known as RESTRICT, can be used to list all of the row values,
The UNION set operator combines all tuples from two relations, excluding duplicate tuples.
If two relations are not union-compatible, then the UNION operator cannot be applied as the results will be
