Ask Question

Consider the following relations and write down expressions for the following queries:

EMP (eid, ename, age, address, salary)

Works (eid, did, hours)

Dept (did, dname, managerid)

  1. List the names of employees who work for the ‘Research’ department for 8 hours using Relational Algebra.
  2. List the name and address of all employees with department number 5 using Relational Calculus.
  3. Find the managerid of managers who manage only departments with budgets greater than 1 lac using SQL.
  4. Find the employee who has highest salary using SQL.
Added 3 years ago
Active
Viewed 1181
Database Management System Computer Science & Engineering
Ans

 

  3. Insufficient information. We are just assuming the Relation Works as Works (eid, did, hours, budget).

    Hence the answer will be as follows:

     

     



Subjects

Data Structures & Algorithm
57 questions
Database Management System
33 questions
Software Engineering
55 questions
Compiler Design
21 questions
Mobile computing
23 questions
Design and Analysis of Algorithm
12 questions
C Programming and Practices
37 questions
Computer Graphics and Multimedia
42 questions

Advertisements

Related Questions

Write the rules of DBA.
2 years ago . by Super Admin

Find out the closure of attribute set (AG), i.e., (AG)+ in R. Set of FD’s are as given: R= {A,B,C,G,H,I}, F= {A → B,A → C,CG → H,B → H}. Is (AG) a super key of R?
2 years ago . by Super Admin

Write the difference between procedural and non-procedural query language.
2 years ago . by Super Admin

Define BCNF. How does it differ from 3NF? Why is it considered stronger than 3NF?
2 years ago . by Super Admin

MindStudy - a preparation hub for all the students. The goal is to make it easier for pupils to get better grades on exams.

Company

Legal Stuff

Help

Copyright © 2025 MindStudy

A product by Shunya Intelliware Solution
(Registered under MSME Uddyam)