Answered step by step
Verified Expert Solution
Link Copied!

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.

.

image text in transcribed

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 employee

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Database And Knowledge Base Systems

Authors: S Krishna

1st Edition

9810206208, 978-9810206208

More Books

Students also viewed these Databases questions