M.C.A. Semester - II
620006 – Databse Management System - II
Assignment – 5 (Relational Algebra)
-----------------------------------------------------------------------------------------------------------------
Q-1. Explain the Following Questions in detail.
1). What is relational Algebra?
2). Explain SELECTION operator with Example?
3). Explain PROJECTION operator with Example?
4). Explain UNION operator with Example?
5). Explain SET DIFFERENCE operator with Example?
6). Explain CARTESIAN PRODUCT operator with Example?
7). Explain RENAME operator with Example?
8). Explain SET INTERSECTION operator with Example?
9). Explain NATURAL JOIN operator with Example?
10). Explain DIVISION operator with Example?
11). Explain ASSIGNMENT operator with Example?
12). Explain INSERT, DELETE and UPDATE operator with Example?
------------------------------------------------------------------------------------------------------------------
Q-2. Query Examples in Relational Algebra and SQL
Consider the relation schemas as follows and Convert Following query into SQL and Relational Algebra.
WORKS (PERSON_NAME, COMPANY_NAME, SALARY)
LIVES (PERSON_NAME, STREET, CITY)
LOCATED_IN (COMPANY_NAME, CITY)
MANAGERS (PERSON_NAME, MANAGER_NAME)
Where manager_name referes to Person_name
A) Find the name of the persons who work for company ‘FBC’
B) List the names of the persons who work for company ’FBC’ along with the cities they live in.
C)
Find the persons who work for company ’FBC’ with a salary of more than
10000. List the names of these persons along with the streets and cities
where they live.
D) Find the names of the persons who live and work in the same city.
E) Find the names of the persons who live in the same city and on the same street as their managers.
F) Find the names of the persons who do not work for company ’FBC’.
G) Find the persons whose salaries are more than the salary of everybody who work for company ’SBC’.
H) Find the names of the companies that is located in every city where company ’SBC’ is located in.
------------------------------------------------------------------------------------------------------------------
