img
Question:
Published on: 23 January, 2022

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 Calculas.
  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.
Answer:

 

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

    Hence the answer will be as follows:

     

     

Subjects
C Programming and Practices Design and Analysis of Algorithm Data Structures & Algorithm Database Management System Software Engineering Mobile computing
Trending

What do you mean by ‘Ternary Relationship’? Define the concept of aggregation with suitable example.
View : 951
23 February, 2025

Consider the following tables:

DEPT (DCODE, DNAME)

EMP (ECODE, ENAME, BASIC, DCODE, DT_JN)

Write down the SQL statements for the following:

  1. For each department, show DNAME and total basic of the employee in the department.
  2. Find out the names of the department where no person is working.
  3. Find out the names of the employees who are working in the department named as ‘ABC’.
  4. Find out the maximum basic among the employees who have joined after year 2000.
View : 1041
23 February, 2025

Write the rules of DBA.
View : 903
23 February, 2025

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 Calculas.
  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.
View : 1072
23 January, 2022

With suitable examples, show how recovery in a database system can be done using Log Files with

  • Immediate updation
  • Deferred updation
View : 1022
23 February, 2025
Random questions
About
MindStudy is a preparation hub for all the students. The goal is to make it easier for pupils to get better grades on exams. We have a list of questions with the best answer for each. Professors, Teachers, and Faculty members from a variety of universities, schools, and institutions throughout the world prepare the Q&A.
Contacts
Shunya Intelliware Solution
Kolkata, WB
Mail us at: info@mindstudy.in

Follow us on:
Streams
Top Subjects
Data Structures & Algorithm Database Management System Software Engineering Compiler Design Mobile computing Design and Analysis of Algorithm C Programming and Practices Computer Graphics and Multimedia Basic Electrical Engineering Radio Frequency and Microwave Engineering Analog Communication Electrical Engineering Management Concrete Technology Design of Reinforced Concrete Structures Power Electronics Irrigation Engineering Surveying Power System I
MindStudy © Copyright 2022, All rights reserved.
Home About Contact