Question: [ 1 5 points ] Consider the following relations and write the appropriate SQL statements to answer the queries given below. EMPLOYEE WORKS _ ON
points Consider the following relations and write the appropriate SQL statements to answer the
queries given below.
EMPLOYEE
WORKSON
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 WORKSON and PROJECT.
iv List the names of employees who work less than hours per week on the Computerization project.
v List the names of employees who
work on more than two projects.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
