Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is the same table i used for the previous one but this has different querries. Dont just copy the answers from the same post

This is the same table i used for the previous one but this has different querries. Dont just copy the answers from the same post please. This is another different set of queries. Thank you image text in transcribed
Workers Name SS# Married (Boolean True/False) Dept (Department Name) Salary BDay (Birth Day-Date Field) Name ManagerName Budget Location ProjectEmp SSH ProjNm (Project Name) An employee can work on multiple projects, but belongs to only one department. All managers are employees. A manager cannot manage more than one department. A project can have multiple employees. All queries must be typed (double spaced) or very, very neatly written. They must be in the given order. Every query must be done in SQL 1. Write a query to get the names and approximate age in 2019 of unmarried employees working on assigned to any project. Project "Miracle" or not 2. Write a query to print out the name(s), salary(s) and month of birth of the employee(s) working on the most projects. 3. Write queries to delete everyone (including the manager) in the "Forestry" Department, but not delete the department. Do not forget to update the Department information as well. 4. write a query to give a 2.5% salary increase to all employees that are senior citizens (65 or over) working on any project that has the word "Computer" in it. This query should work regardless of the current year/date. s. Write a query to print out the names of employees working on all projects. 6. Write a query to list the names and budgets of the departments where all employees are currently assigned to a project (no one in the department is not working on a project)

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

Online Market Research Cost Effective Searching Of The Internet And Online Databases

Authors: John F. Lescher

1st Edition

0201489295, 978-0201489293

More Books

Students also viewed these Databases questions

Question

Why We Listen?

Answered: 1 week ago