The Relational Model: Introduction, QBE, and Relational Algebra
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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
