SQL and Queries access
Assignment 6: SQL and Queries
All assignments must be completed individually. Do not share your work or use another student’s work in anyway. Assignments are to be completed without the help of a private tutor, if you need assistance with this assignment please post on the course forums, e-mail a TA/instructor, or attend an office/consulting hour.
See OWL Assignment tab for assignment due date and late policy.
You MUST backup your work. Extensions will not be given for lost or corrupted files. This is especially important if you are using MyVLab (should only be needed for Apple computer
users). If you will be using MyVLab, you MUST understand how to transfer files between your local computer and MyVLab before attempting this assignment.
For Part 1 you MUST write the SQL by hand. Using any tool to automatically generate the SQL such as the query design tool will result in a 0 grade for this assignment. You must follow the
strict formatting guidelines for Part 1 to show that your SQL was created by hand.
Part 1
Situational Setup
It has been a few years since your business was launched and it is experiencing tremendous success. You now have departments in Winnipeg, Toronto, and Montreal as well as dedicated teams of employees. To manage these employees, track their time worked, absences, and the projects they are working on, you have created a Human Resources (HR) database. An ERD of this database is shown below:
my wechat：_0206girl
Don't hesitate to contact me
