Get details of employee working on both comp354 and comp345, Database Management System

Assignment Help:

Consider the relations

EMPLOYEE(emp#, name)
ASSIGNED_TO(project#, emp#)
PROJECT(project#, project_name, chief)
Express the subsequent queries in Relational Algebra

(i) Get details of employee working on both comp354 and comp345 project numbers.
(ii)Find out the employee number of employee who do not work on project comp678

(i) EMPLOYEE (ASSIGNED TO ÷∏project # (σ(project#='comp351' ∨ project#='comp 345 ASSIGNED _TO)))
(ii) ∏Emp#(EMPLOYEE)-∏Emp# (project#='c 678' ASSIGNED_TO))

Related Discussions:- Get details of employee working on both comp354 and comp345

Database, real life situations where database management system are most su...

real life situations where database management system are most suitable

Explain an attributes, What are attributes? Give examples. An entity is...

What are attributes? Give examples. An entity is shown by a set of attributes. Attributes are descriptive properties possessed by every member of an entity set. Example: pos

File organization, what is file organization? what are file organization te...

what is file organization? what are file organization techniques.explain in detail? explain random file organization technique, multikey file organization technique?what is indexin

Extended e-r features, Although, the essential features of E-R diagrams are...

Although, the essential features of E-R diagrams are enough to design many database situations. Though, with more difficult relations and advanced database applications, it is need

What is a transaction? and how does it differs from update, wh

Customer service, as a customer service employee, explain five measures you...

as a customer service employee, explain five measures you would recommend a displeased student to patronise a school canteen

Many-to-many relationship, Many-to-many : Entities in A and B are related w...

Many-to-many : Entities in A and B are related with any number of entities from each other. Example: Taught_by Relationship among course and faculty. One faculty member ca

Object query language and odmg schema , (a) Provide the description of t...

(a) Provide the description of the following ODMG schema in the Object Definition Language (ODL). (b) Based on the above object database, write the following queries i

The transactions, The Transactions- A transaction is definite as the unit o...

The Transactions- A transaction is definite as the unit of work in a database system. Database systems that deal with a huge number of transactions are also termed as transaction p

Create a technology web server, Database design Database tables will be...

Database design Database tables will be created for you on the Technology web server. The schema will be as follows. Please note that this is a simplified database structure, d

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages