Home/ Questions/Q 13727
Next
In Process

SIKSHAPATH Latest Questions

vivkkk
  • 0
  • 0
Asked: 2022-03-20T20:02:17+05:30 In:

Consider the following schema: Emp(eno,ename,ph_no,address,salary,dno) Department(dno,dname,location) Project(pno, dno,status) Works_On(eno,pno,hours) Solve the following queries using Relational Algebra operations a. List eno …

  • 0
  • 0

Consider the following schema:
Emp(eno,ename,ph_no,address,salary,dno)
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​

Share

    1 Answer

    2. Naveen

      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”

    Leave an answer

    You must login to add an answer.

    Need An Account,