The Relational Model: Introduction, QBE, and Relational Algebra
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →
Order Instructions
Assignment
M2 Your Turn Exercise: 2-1— 2-12
Instructions
Note: This Exercise includes answering questions that may involve screenshots of actions you have done using the database files from Module 2.
There are six files to complete this exercise:
o M2 – 12 Exercise.docx
o M2 JCConsulting.accdb
o M2 JCConsulting.sql
o M2 JCConsulting.sql.bak
o M2 MSSQL Server Data_JCConsulting.sql
o M2 MySQL_JCConsulting.sql
• All tasks will require access files, BUT not all tasks will need the extra files
included and attached for each exercise.
• You will have to read the document titled, “M2 Steps for Completing Module 2
Exercise 2-1_2-12” for the step-by-step instructions to see what is required and
follow the directions to complete exercises 2-1 through 2-12, listed below:
o 2-1 Create a query to list the task IDs, categories, and task descriptions in
the TaskMasterList table.
o 2-2 Find the table in the Database category.
o 2-3 Using the TaskMasterList table, list the TaskID, Description, Per, and
Estimate fields to select the records with a Per field value of Hour and an
Estimate field value greater than or equal to 150.
o 2-4 Using the TaskMasterList table, list the TaskID, Description, Per, and
Estimate fields to select the records with a Per field value of Hour or an
Estimate field value greater than or equal to 150.
o 2-5 Calculate the annual salary for each employee using the Salary field,
which contains a monthly value multiplied by 12. Include the employee’s
last name, title, and annual salary in the results.
o 2-6 What is the average salary value for each job title? Also include the
total number of employees that share the same title.
o 2-7 List the task ID, description, and category ID for each task in the
TaskMasterList table. Sort the records in ascending order by description.
o 2-8 List each client ID and name, along with their related project IDs and
project notes.
o 2-9 Change employee records with the job title of “Project Lender” to
“Project Manager.”
o 2-10 Delete all ProjectLineItems records for the project with a project ID of
20.
o 2-11 Create a new table containing the client name, as well as the project
IDs and project start dates prior to 1/1/2020. Name the table
ClientProjectsPriorTo2020.
o 2-12 List all information about ClientID 19 from the Clients table.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds