Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Suppose the following tables are part of a project management database of a company, where keys are underlined: E(ssn, name, salary) stores the information of
Suppose the following tables are part of a project management database of a company, where keys are underlined: E(ssn, name, salary) stores the information of employees, P(pid, title, budget) stores the information of projects, and M(ssn, pid, start, end) stores the information of management of projects by employees.
.
6) Write an SQL query to return the ssns of employees that managed at most 1 project 7) Write an SQL query to return the ssns of employees that managed no project in last 6 8) Write an SQL query to return the name of employees that managed only 1 project which 9) Write a SQl query to give everyone a 10% salary who managed 2 projects to completion 10) Write an SQL query to delete all the projects from table P that are NOT managed by any completed or ongoing in last 6 months. months. completed 2 years ago. in last year employeeStep 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