The purpose of this assignment is to practice automating queries through scheduling a job on the system.Each month the workforce management team calculates PTO/SICK time remaining for the rest of the year in order to plan vacations. The team has requested a report that lists the Employee, Job Title, Vacation Hours, and Sick Hours. The team would like the report to generate on the first day of each month.For this assignment, you will need to complete the following steps to enable the SQL Server Agent:Go to "RUN:" in Windows Explorer and type "services.msc."Double click on "SQL Server Agent (MSSQLSERVER)" and change it to "automatic."Close and launch "SQL Server Configuration Manager."Left click on "services."Start SQL Server Agent.Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to a Microsoft Excel file for a visual check of accuracy.Create a Microsoft Word document that includes the SQL query code used to execute the steps below in the "AdventureWorksDW2017" database.Write a SELECT statement to access the Employee, Job Title, Vacation Hours, and Sick Hours information.Schedule a job to run on the first day of each month and title it "PTO/SICK Report."Take a screenshot of the report setup screen to illustrate how you designed the report. Paste the screenshot into a Word document as record of the report.Create a SQL transaction that manages the scheduling of PTO/SICK Report as well as a periodic database backup.Copy and paste the SELECT query, screenshot of the scheduler configuration, and the SQL transaction into a Word document.Compile the Excel data file and the Word document into a .zip file and submit to your instructor.APA style is not required, but solid academic writing is expected.

Discuss the key components of human resource management. Pick at least four concepts from chapter nine and describe how these concepts interrelate to individual performance on a team.Review table 9.2 and select one of the dimensions listed, note why it was chosen and how you relate to this behavior. If you have a personal experience, please share.How do leaders select the best talent? What are some tools they can use to select the best-talent?At least one scholarly (peer-reviewed) resource should be used. Please ensure to use information from your readings and other sources from the UC Library. Use APA references and in-text citations.Required Reading:Chapter’s 9 & 10 in the textURBONAVIČIŪTĖ, K., & MAKNICKIENĖ, N. (2019). Investigation of Digital Retail Companies Financial Performance Using Multiple Criteria Decision Analysis. Science: Future of Lithuania, 11, 1–9. https://doi.org/10.3846/mla.2019.9737 http://search.ebscohost.com/login.aspx?direct=true&AuthType=shib&db=a9h&AN=141392864&site=eds-live&custid=s8501869&groupid=main&profile=eds_newOptional Resources:Chapter 9 & 10 Journal articlesJournal Article 9.1: Crossman, B. and Crossman, J. (2011) ‘Conceptualising followership – a review of the literature’, Leadership, 7(4): 481–497.Journal Article 9.2: Agho, A.O. (2009) ‘Perspectives of senior-level executives on effective followership and leadership’, Journal of Leadership & Organizational Studies, 16(2): 159–166.Journal Article 9.3: Larsson, M. and Nielsen, M.F. (2017) ‘The risky path to a followership identity: from abstract concept to situated reality’, International Journal of Business Communication. DOI: 10.1177/23294888417735648, pp. 1–28.Journal Article 10.1: Cook, A. and Glass, C. (2015) ‘Do minority leaders affect corporate practice? Analyzing the effect of leadership composition on governance and product development’, Strategic Organization, 13(2): 117–140Journal Article 10.2: Dreher, G.F. (2003) ‘Breaking the glass ceiling: the effects of sex ratios and work-life programs on female leadership at the top’, Human Relations, 56(5): 541–562.

In this project, we will write a program that simulates the rolling of dice, performs many rolls, and determines the frequency for each possible sum of the dice. We will create a kind of bar graph called a histogram and display it in two forms - one horizontal and one vertical. This project will require you to write several loops that process the integer variables in an array - as well as how to use a method (even if you do not understand it's inner workings).You can find an initial version of the Histogram.java and HistogramCLI.java source files in project2.zip. As always, download and unzip this file on your removable media (or your own computer). You may find it helpful to create/save a Dr Java project file in the project2 directory.How this program will work is as follows:Prompts user for how many dice to roll (1 to 3).Prompts user for how many sides each die should have (2 to 9).Asks user how many times to roll the dice (1000 to 2 billion).Rolls the dice that number of times.Creates a Histogram object and determine how tall each bar should be.Calls the Histogram object's methods for drawing the histogram, both horizontal and vertical. (Check out the sample output below, to see how this might look.)For this project, you will be working in both classes, writing the code that enables the program to work. The individual steps are in the comments in the files, but I'll also go over them briefly here:In HistogramCLI.java...Declare your variables. (Details in code comments)Set up one do-while loop, that will encompass three others, along with the majority of the code in the main method. It will allow repeated execution of the rest of the program, until the user indicates to stop. That outermost do-while loop will encompass steps 3-10 below.Prompt the user for how many how many dice to roll (1 to 3), but only allow a number within the specified range.Prompt the user for how many sides each die should have (2 to 9), but only allow a number within the specified range.Prompt the user for how many times the dice should be rolled (1000 to 2 billion), but only allow a number within the specified range.Set your counting array to zero, using a loop.Calculate the minimum and maximum indices, and initialize the "counts" array. The minimum index is the smallest possible sum of the dice, while the maximum index is the largest possible sum.Start rolling the dice. After each roll, increment the element of the "counts" array at the index corresponding to the sum.Construct the Histogram object and call it's drawing methods. Study the Histogram class so that you are familiar with it's constructor and other methods, know how they work, and know what they return (or don't return).Ask if the user wants to do it again. Don't forget to close your outer loop and test the condition, specified in the code comments.In Histogram.java...We may have very large values in the values array supplied as a parameter to the constructor. Since we want to limit the size of the histogram bar graph to maxLength, we need to scale the data in the values array when we copy it into the instance copy of the data in the array. This consists of two loops. The first loop finds the largest value in the values array. (Declare, initialize, and use a variable named something like maxValue).The second loop multiplies each value in the values array by the max length we want for bars (maxLength) and divides by the largest value found (maxValue). Remember the limitations of multiplication and division for integer variables. You may need to cast the integer values to double for the calculation and cast the result back to integer to update the value in each counts array element with good "resolution". You can also get good resolution by performing integer multiplications and divisions in the correct order.In the drawHor method, your code must draw a horizontal bar graph of the data in the values array. (See sample output) This will require two nested loops. The outer loop will go through each element of the values array, and the inner loop will print an asterisk from 1 through the value in the outer loop element of the values array. You may also want to print the values array integer at the end of each bar of asterisks, even though this is not in the sample output.In the drawVer method, your code must draw a vertical bar graph of the data in the values array. (See sample output) This is a little trickier than the horizontal bar graph. You still need two nested loops. The outer loop will count down through all the values from maxLength to 1 to print each line. The inner loop will print a piece of each line for each value (index into the values array). If the count for the value is greater than or equal to the decreasing count of the outer loop, print an asterisk with two spaces after it. If the count for the value is not greater than or equal to the value of the outer loop count, print an equivalent number of spaces to maintain the column alignment but not show the "bar" in this column. For the last line of output, print the numbers from minIndex up to maxIndex; for each number, print that number followed by two spaces (if the number is less than 10) or one space (if the number is greater than or equal to 10).To make sure your program is working correctly, try it out with different numbers of dice, different numbers of sides per die, and different numbers of rolls. Remember, more dice and more rolls will slow down the rolling portion of the program.