By the relations get details of employees working in sql, Database Management System

Assignment Help:

Consider the relations:
PROJECT(proj#,proj_name,chief_architect)
EMPLOYEE(emp#,emp_name)
ASSIGNED(proj#,emp#)
Use relational algebra to express the subsequent queries:
(i) Get details of employees working on project COMP33.
(ii) Get the employee number of employees who work on all projects.
(iii) Get details of project on which employee with name ‘RAM' is working.

Ans:(i) EMPLOYEE ∏Emp#(σproject#='comp33'(ASSIGNED))
(ii) ∏Emp#(EMPLOYEE)-(ASSIGNED ÷∏project#(PROJECT))
(iii) PROJECT (∏project#(σEmp_name='RAM'(EMPLOYEE) ASSIGNED))


Related Discussions:- By the relations get details of employees working in sql

Development of large scale distributed real systems, Question: (a) What...

Question: (a) What are the challenges in the development of Large Scale Distributed Real Systems? (b) What is backward engineering and forward engineering in a design packa

Organic compounds, #question.explain diversity and magnitude of organic com...

#question.explain diversity and magnitude of organic compounds and general properties?

Type of views-data control, Type of views :  Simple views and Difficult ...

Type of views :  Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One

Explain the structure of well formed formulae, Explain the structure of wel...

Explain the structure of well formed formulae in relational calculus. Ans: a. An atom is a formula b. If P1 is a formula, after that so are ¬P1 and (P1) c. If P1 and P2 a

Load - unload utilities, These permit the user to unload a database or part...

These permit the user to unload a database or parts of a database and reload the data on the similar machine, or on another machine in a dissimilar location. This can be useful in

Microsoft access database assigment, Hello.I have database access assignmen...

Hello.I have database access assignment which consist of creation Form, Subform, Calculation, Macros

Designing a Human Resources Database LASA1, Scenario: You are a freelance ...

Scenario: You are a freelance database designer who has just been contacted by a small software development company named Altair Software. The president of the company has asked

Mobile database, write short note on mobile database

write short note on mobile database

Each statement should have a where clause, Submit SQL SELECT Statements to ...

Submit SQL SELECT Statements to demonstrate several reports off your database, according to the following guidelines: You must submit at least 5 SELECT Statements. Each

Give the levels of data abstraction, Give the levels of data abstraction? ...

Give the levels of data abstraction? There are three levels of Data Abstraction a) Physical level b) logical level c) view level

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd