MindStudy - MindStudy

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)

List the names of employees who work for the ‘Research’ department for 8 hours using Relational Algebra.
List the name and address of all employees with department number 5 using Relational Calculas.
Find the managerid of managers who manage only departments with budgets greater than 1 lac using SQL.
Find the employee who has highest salary using SQL.

Answer:

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

Hence the answer will be as follows:

Subjects

Compiler Design Data Structures & Algorithm Mobile computing Software Engineering Database Management System C Programming and Practices

Trending

Discuss the ACID properties of transaction.

6 June, 2023

What is the need for normalization? Explain 2nd and 3rd normal form with example.

Consider the following relation:

EMP_PROJ { SSn, Pnumber, Hours, Ename, Pname, Plocation}

Assume { SSn, Pnumber} as primary key.

The dependencies are {SSn, Pnumber}→ Hours; SSn →Ename; Pnumber → {Pname, Plocation}.

Normalize the above relation into 2NF.

23 January, 2022

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

6 June, 2023

Write short notes on the following:

6 June, 2023

What is attribute inheritance? Describe the concept of specialization and generalization in the context of ER-data model.

6 June, 2023

What are the application of Computer Graphics ?