Provide screen shot the resulting views
Ensure your small database is normalized to at least the third normal form.
Create a database to contain the tables for this assignment. Name the Database with the first four letters of your last name and "database", example: GARRDatabase. Take a screenshot of the executed code and the results.
Job Title
Job Description
Submission of Individual and Learning Team assignments
For each assignment, make sure that you provide a single MS Word document that contains the following items:
Results will include the execution status statement results
A short analysis of the query (at least two complete sentences) stating if the query executed as expected.
Last name
First name
Area Code
Phone Number
No. of Exemptions (Ex. 0, 1, 2, 3, 4)
Marital Status (S, M, HOH)
Select all the records in the Job Title Table and display. Take a screenshot of the executed code and the results.
Write a query, that shows the employee's name in one column, entitled "Full Name" in the following format - Bob Smith.
Join two tables in the example database and use LIKE to restrict the records based on Telephone Area Codes. Take a screenshot of the executed code and the results.
Create a query that shows all employees whose name has the second letter of either an 'a','e','o' or 'u'.
A title page including your name. Your name should also be included in the header of the documents.
For Learning Teams, simply include your team name in the header. However, each team member's name should be on the title page.
Week Three
Enter new records into the Employee and the Job Title tables for workers identified in the Week Three Data Sheet in the materials. Take screenshots of the fully executed code.
Increase all other employees' salaries by 4.9% percent.
Choose an employee from the Employee table and delete that employee.
Submission of Individual and Learning Team assignments
For each assignment, make sure that you provide a single MS Word document that contains the following items:
Results will include the execution status statement results
A short analysis of the query (at least two complete sentences) stating if the query executed as expected.
Calculate the average, minimum and maximum salary for exempt employees. Using the UNION command also display the same information for the non-exempt employees. (Output shows Alias).
Write one SQL Query to calculate the minimum salary for all employees. (Output shows Alias).
Save a copy of the completed report in .pdf format.
All SQL query statements (copy and paste from your query editor). Code is to be manually typed. Due to the large volume of records associated with the Learning Team assignment; the import function may be used.
Copy and paste the results, or provide a screen shot of the resulting views. (Select *)
Write one SQL Query to calculate the minimum salaries for Employees by Job Title. (Output shows Alias).
Take a screenshot of the code and results from each of the queries above and paste into a Word document.
Submission of Individual and Learning Team assignments
For each assignment, make sure that you provide a single MS Word document that contains the following items:
Results will include the execution status statement results
A short analysis of the query (at least two complete sentences) stating if the query executed as expected.