Solved by: AllAcademicHelp.com
| October 30, 2018
Write my research paper1. Import the Department and Employee tables into Access. (10 points)a. Use TableName_ as the naming convention for the tables: For example, my EUID is ks0776; I will name the tables as Department_ks0776 & Employee_ks07762. Establish a relationship between tables in MS Access. (10 points)3. Answer the following questions by writing SQL statements in MS Access:
a. Find all employees working in Westlake who make $100,000 or more in salary. Sort your data by Salary in a descending order. (10 points)
b. Find all employees who have ‘Director’ or ‘VP’ in their titles. This should include Sr. Directors and SVPs as well. (10 points)Hint: Use LIKE. Note that MS Access does not use ANSI SQL, hence the wildcard characters used in MS Access are different. Please follow https://www.techonthenet.com/access/queries/like2007.php for details.
c. Generate the count of employees and average salaries by Department for the departments where the average salary is greater than $70,000. The outcome should look something like: (the numbers below are just examples…your numbers will be different). Make sure that you use the Column headers shown in the outcome. (15 points)Department EmployeeCount Avg.SalaryAccounting 10 98500Finance 8 88300Sales 6 105010……….additional rows in the outcomed. Generate a list of all employees with their names, titles, salaries, department names, and Department City. Note, the outcome should include all employees regardless of whether they belong to a department or not. (10 points)
Generate a list of all employees from Accounting or Finance departments who are 50 years or older, and are making more than $75,000.Hint: You will have to use the DOB and the Date() function to calculate the age. (15 points)©Copyright 2000-2018. All Rights Reserved. TermPaperChampions.com: The most reliable provider of custom academic papers. Our writers are here to help you complete papers from all disciplines and academic levels . You can always trust us to deliver.
Get a 15 % discount on an order above $ 50Use the following coupon code :tpc15
READY TO PLACE AN ORDER