Consider the following schema:
Department(dno,dname,location) Project(pno, dno,status) Works_On(eno,pno,hours)
Solve the following queries using Relational Algebra operations
a. List eno and dno from Emp where dno as ’20’
b. List eno,ename,dno,dname from Emp and Department.
c. List eno,ename,pno from Emp and Works_On where ename as ‘Ajay’
d. List all employees having salary greater than 50000 and dno as 30
e. List pno,dno,dname and status of all projects having dno as 50
Consider the following relational schema.
Employee (eno, NIC, ename, address, dnumber)
Department (dno, dname)
Project (pno, pname,location)
Work_on (eno, pno, hired_date, hours)
Considering the following data types for the above schema, create the following relational database using CREATE TABLE SQL statement. Ensure that appropriate referential integrity constraints (foreign keys) are met. Save the script as “CreateDB.sql”