Question: [ 1 5 points ] Consider the following relations and write the appropriate SQL statements to answer the queries given below. EMPLOYEE WORKS _ ON

[15 points] Consider the following relations and write the appropriate SQL statements to answer the
queries given below.
EMPLOYEE
WORKS_ON
PROJECT
DEPENDENT
i) List the Fast name, last name, and SSN of all employees who works on a project called 'ProductY'
or 'ProductZ' and have dependents
ii) List the names of all projects which have exactly three employees and have no dependents.
iii) What is the degree and cardinality of the relation produced by the cartesian product of
WORKS_ON and PROJECT.
iv) List the names of employees who work less than 5 hours per week on the 'Computerization'
project.
v) List the names of employees who work on more than two projects.
 [15 points] Consider the following relations and write the appropriate SQL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!