Answered step by step
Verified Expert Solution
Question
1 Approved Answer
[ 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started