445355 SQL server

Stage 2: data. Your document should include screen shots of the SQL tab from SQL Server Management Studio for each SQL statement. Using the database and tables from Week Two, incorporate any recommended changes by the instructor and write SQL statements and enter the records into the Employee table for the workers identified in the Employee Files for the administrative offices and the Del Mar location. Check the results by selecting all of the columns from both of your tables. Write SQL queries using Between, and Like: • Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. (Use salary to restrict the data.) • Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. (Use hire dates to restrict the data.) • Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. (Use telephone area codes to restrict data.) • Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. (Use age to restrict data.) Using the updated database, write the following queries using the SQL GROUP statement: • Group employees by job classification: Select the employees' last names and group them by EEO-1 Classification. • Group employees by salary: Select the employees' last names and group them by salary. • Group employees by salary within their job classification: Select the employees' last names and group them by salary within their EEO-1 Classification. • Select the employees' last names and group them by salary within job titles that are grouped into exempt and non-exempt. Submit your database by creating a backup of your database and posting the “.bak” file generated by SQL Server Stage 3: Using the database and tables from Week Three, incorporate any recommended changes by the instructor and write SQL statements. Note: Create a backup of your database before running queries that modify data. • Choose an EEO-1 Classification: Increase all employees' salaries that have: the selected EEO-1 classification by 10%. • Increase all employees' salaries by 5%. • Choose an employee from the employee table; delete this employee. Note: Restore your database before running the following queries. Using the database and tables from Week Three, write SQL statements to: • Calculate the average salary for all employees. • Calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees. • Calculate the maximum salary for all employees. • Calculate the minimum salary for exempt employees and the minimum salary for non-exempt employees. • Calculate the minimum salary for all employees. Submit your database by creating a backup of your database and posting the “.bak” file generated by SQL Server Please create a backup of the database “.bak” file generated by SQL Server Information: 1. Analyze the current Chart of Accounts and create an entity relationship diagram of the database that your team will create based on the chart. Remember, a database consists of multiple tables. Your team will also develop a project plan defining all tasks and work assignments for each team member. Post your ERD and project plan in a single MS Word document. Please note that the ERD must be created using a drawing tool such as MS Visio, but copy and pasted into the MS Word document. 2. Create the tables based on your design and feedback from the instructor in a SQL Server database. Prepare test data and load it into the SQL Server database. Load data from the Chart of Accounts making sure to only store the data into the relevant tables. Every tables needs to have data added to it with several rows of data per table. In addition to posting your database, post a MS Word document to the individual forum of the student designated as the “team poster” for this week. This MS Word document should include the SQL code used to create your database and tables as well as load the data. Your document should include screen shots of the SQL tab from SQL Server Management Studio for each SQL statement. 3. Create and test an account number query. This query should retrieve account data from multiple tables using joins to gain meaningful information from the data. In addition to posting your database, post a MS Word document to the individual forum of the student designated as the “team poster” for this week which includes the SQL code used in the SQL statements above. Your document should include screen shots of the SQL tab from SQL Server Management Studio for each SQL statement. 4. Create and test SQL database Chart of Accounts report. The report should organize the data in a manner that is presentable to an individual at the management level: fields should have unambiguous names, data should be grouped and sorted, subtotals should be included, a clean looking font should be used, etc. The report should look aesthetically pleasing. In addition to posting your database, post a MS Word document to the individual forum of the student designated as the “team poster” for this week which includes the SQL code used to populate the report as well as an export of the report from Business Intelligence Development Studio. Adding the SQL code to the exported MS Word document of the report will be the best way to post this assignment.