CPSC285 DOM Assignment 5 Database Design & Programming SQL Queries

Anonymous
timer Asked: Feb 18th, 2019
account_balance_wallet $15

Question Description

write those queries (same as attached file)

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.

  • Write a query to get the names and approximate age in 2019 of unmarried employees working on Project "Miracle" or not assigned to any project.
  • Write a query to print out the name(s), salary(s) and month of birth of the employee(s) working on the most projects.
  • 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.
  • 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.
  • Write a query to print out the names of employees working on all projects.
  • 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).

Make sure they work correctly in access, feel free to attach a made up access file to text your queries

CPSC 285 - DATABASE DESIGN & PROGRAMMING ASSIGNMENT 5 – SQL Queries Date: 02/15/19 Due On: 02/20/19 Assume that you have the following tables in a database (same as Assignment 4): Workers Name SS# Married (Boolean - True/False) Dept (Department Name) Salary BDay (Birth Day – Date Field) Department Name ManagerName Budget Location ProjectEmp SS# 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 Project "Miracle" or not assigned to any project. 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. 5. 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).

Tutor Answer

Demsey
School: Duke University

Atta...

flag Report DMCA
Review

Anonymous
Excellent job

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors