CPSC285 DOM Assignment 5 Database Design & Programming SQL Queries

Programming

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

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational