I’m working on a computer science question and need support to help me study.
You will need to install and use Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) for this Assessment. You can download the latest versions of these free software products here:Microsoft SQL Server ExpressMicrosoft SSMundefinedNorthwind Database Deployment ScriptIt is very important that you watch the module videos associated with DML and DCL prior to completing the assessment. Navigate to the Academic Tools area of this Module and select Library then Required Readings to access your texts and videos.Task 1 – Retrieving Data Using Advanced QueriesOnce the Northwind database is successfully deployed, generate SQL statements to address the problems below. Use the following database design diagram as a guide in forming your statements:Northwind Database Design DiagramYour assessment report needs to show both the generated SQL statements and confirmatory screenshots verifying problem completion.Problem 1: Create a report of “seafood” and “produce” products, showing ProductID, ProductName, and CategoryName. Incorporate an inner join condition for this query.Expected OutputProblem 2: List the last name, first name, title, and salary of company employees with salaries above the company average. Use a non-correlated subquery in the SQL statement.Expected OutputProblem 3: List the average salaries for employees in Seattle and London. The averages need to be calculated on a per city basis. Use a union operation to generate the results. (Hint: Use one SQL statement to calculate the average salary for one city and another almost identical SQL statement to calculate the average salary for the other city.)Expected OutputProblem 4: Show the product names for products that have been ordered in quantities equal to or exceeding 120. Use a non-correlated subquery in the SQL statement.Expected OutputProblem 5: List the supplier names and cities for suppliers that reside in the same cities as Northwind employees. Use a non-correlated subquery in the SQL statement.Expected OutputProblem 6: Display the names of Northwind employees that manage territories located in the Western region. Use inner joins in the SQL statement linking the Employees, EmployeeTerritories, Territories, and Region tables. Do not show duplicate employee names in the result set.Expected OutputProblem 7: Display customer names, cities, and order IDs for customers residing in Madrid or Paris. Show all customers regardless of whether they have placed orders or not. Use an outer join in the SQL statement.Expected OutputProblem 8: Display a combined list of supplier and shipper names along with their phone numbers. Use a union operation in the SQL statement. Present the results in alphabetical order based on CompanyName.Expected OutputProblem 9: Show the employee names, salaries, and countries for employees that have salaries above the average salary within their respective countries. Use a correlated subquery in the SQL statement.Expected OutputProblem 10: Display the names of products supplied by vendors in the USA and Norway. Show the product country in the result set. Present the results in alphabetical order by product name. Use an inner join in the SQL statement.Expected OutputTask 2 – Transactions and Security ImplementationsYou will need to change the authentication method used by Microsoft SQL Server in order to complete this task. Perform this change using the following guidance document:Enabling SQL Server AuthenticationYou can now proceed with work on the task problems below. Your assessment submittal needs to show both the generated SQL statements and confirmatory screenshots verifying problem completion.Problem 1: Create a view called EmployeeDirectory that displays the first name, last name, title, and phone extension of all employees in the company.Problem 2: Create a stored procedure that increases an employee’s salary by a raise percentage. The skeleton of the stored procedure is provided below.CREATE PROCEDURE [email protected] INT, @RaisePercentage DECIMALAS<REPLACE WITH YOUR SQL CODE>The equation for computing a new salary is as follows:New Salary = Old Salary * (1 + Raise Percentage/100)If an employee with EmployeeID = 9 gets a 5% raise, the stored procedure call would be as follows:EXEC GiveEmployeeRaise @EmployeeID = 9, @RaisePercentage = 5;Problem 3: Create and execute a transaction block that contains two DML statements. The first statement updates the title for all employees to “President.” The second statement inserts a new region record with a RegionID = 10 and a RegionDescription = “Antarctica.” Incorporate these statements within the SQL block specified below:BEGIN TRANSACTION<REPLACE WITH INSERT/UPDATE STATEMENTS>SELECT * FROM Employees;SELECT * FROM Region;ROLLBACK TRANSACTIONSELECT * FROM Employees;SELECT * FROM Region;Execute the completed SQL block in a Microsoft SSMS query window.Briefly explain what happened with the execution of this transaction. Provide the before and after screenshots of the data contained within the Employees and Region tables. Please note the query results will appear in 4 separate sections in the Results area of Microsoft SSMS following execution of the above SQL block.Problem 4: You are asked to add three new products to an existing order with OrderID = 11061. The additional records need to be added to the OrderDetails table with the following information:Record 1OrderID = 11061ProductID = 62UnitPrice = 45Quantity = 10Discount = 0Record 2OrderID = 11061ProductID = 70UnitPrice = 14Quantity = 25Discount = 0Record 3OrderID = 11061ProductID = 1000UnitPrice = 100Quantity = 5Discount = 0Incorporate the SQL insert statements for the new records into the transaction block specified below and execute in a Microsoft SSMS query window:BEGIN TRANSACTION NewOrderDetailsBEGIN TRY<REPLACE WITH INSERT STATEMENTS>COMMIT TRANSACTION NewOrderDetails;END TRYBEGIN CATCHROLLBACK TRANSACTION NewOrderDetailsEND CATCHSELECT * FROM OrderDetailsWHERE OrderID = 11061;Briefly explain what happened with the execution of this transaction. Do the new records get inserted into the OrderDetails table? If not, why?Problem 5: Create four new roles in the Northwind database:SalesPersonSalesManagerHRpersonHRmanagerProblem 6: Use Data Control Language (DCL) statements that manage database user permissions.Grant select, insert, and update permissions for Sales-related tables (Orders & OrderDetails) to the SalesPerson role.Grant select and delete permissions for Sales-related tables to the SalesManager role.Grant select permissions for the EmployeeDirectory view to the SalesPerson and SalesManager roles.Grant select, insert, and update permissions for HR-related tables (Employees & EmployeeTerritories) to the HRperson role.Grant select and delete permissions for HR-related tables to the HRmanager role.Grant execute permission for the GiveEmployeeRaise stored procedure to the HRperson roleProblem 7: Create four new users named Jane, Joan, Joe, and James. Use the CREATE LOGIN and CREATE USER commands to accomplish the work. Each established Northwind database user account must be associated with an applicable SQL Server login account (e.g., CREATE USER Jane FOR LOGIN Jane). Please note, you must establish the SQL Server login accounts before the database-level usernames. Use the following password for each of the four SQL Server login accounts: P@$$w0rdProblem 8: Grant the roles specified below to Jane, Joan, Joe, and James.Give Jane the role of SalesPerson.Give Joan the role of SalesManager.Give Joe the role of HRperson.Give James the role of HRmanager.Use the ALTER ROLE command to accomplish the role granting work.ALTER ROLE <role_name> ADD MEMBER <user_name>;Problem 9: In Microsoft SSMS, right-click on the SQL Server instance at the top of the tree in the Object Explorer window. Select the Connect item from the right-click menu.The login prompt will appear. Select “SQL Server Authentication” from the Authentication drop down box. Enter “Jane” and “P@$$w0rd” into the Login and Password fields, respectively. Click on the Connect button when finished.You will now be connected to the SQL Server instance as “Jane.”Expand the Databases item under “Jane.” Right-click on the Northwind database item and select the New Query item in the right-click menu.Generate SQL statements in the query window to do the following:Update the order quantity to 50 for OrderID = 10249 and ProductID = 51.Delete the record in OrderDetails with OrderID = 10251 and ProductID = 65.Select all of the records from the Employees tableSelect all of the records from the EmployeeDirectory view established in Problem 1 of Task 2Provide screenshots of the SQL statement outputs. Provide a brief explanation for any statement that failed to executeProblem 10: Connect to the Northwind database as “Joan” using the steps specified in Problem 9 of Task 2. Generate SQL statements in the query window to do the following:Update the order quantity to 60 for OrderID = 10249 and ProductID = 51.Delete the record in OrderDetails with OrderID = 10251 and ProductID = 65.Select all of the records from the Employees tableSelect all of the records from the EmployeeDirectory view established in Problem 1 of Task 2Provide screenshots of the SQL statement outputs. Provide a brief explanation for any statement that failed to executeProblem 11: Connect to the Northwind database as “Joe” using the steps specified in Problem 9 of Task 2. Generate SQL statements in the query window to do the following:View all of the records contained in the Orders table.Give a 5% raise to the employee with EmployeeID = 9 using the GiveEmployeeRaise stored procedureSelect all of the records from the Employees tableSelect all of the records from the EmployeeDirectory viewProvide screenshots of the SQL statement outputs. Provide a brief explanation for any statement that failed to executeProblem 12: Connect to the Northwind database as “James” using the steps specified in Problem 9 of Task 2. Generate SQL statements in the query window to do the following:Give a 10% raise to the employee with EmployeeID = 8 using the GiveEmployeeRaise stored procedure established in Problem 2Update the title to “Gamemaster” for the employee with EmployeeID = 9Select all of the records from the Employees tableSelect all of the records from the EmployeeDirectory viewProvide screenshots of the SQL statement outputs. Provide a brief explanation for any statement that failed to execute.
what society has played role on individual’s choice and behavior?
what society has played role on individual’s choice and behavior?.
1. My thesis is society has positive and negative influences on individual’s behavior.2. write a conclusion for the essay3. check the grammar errors4. rephrase the sentence if it didn’t make sense, and make the whole article more fluent- I don’t finish the last paragraph, please add more analysis5. edit it with red color at the end of the original context, please don’t delete the original sentence6. Does intext quotation make sense and does I effectively unpack the quote??6. below are articles that I analysis in my essayhttp://www.online-literature.com/forums/showthread.php?67465-Salvation-A-short-essay-by-Langston-Hughes Salvation,Hugheshttps://learn.uncg.edu/courses/soc101-ischool/content/episode7/pdf/WalkBy.pdf Just walk by, Staplehttps://www.nytimes.com/2007/08/01/opinion/01munoz.html Leave your name at the border, Munozhttp://orwell.ru/library/articles/elephant/english/e_eleph Shooting the elephant, George Orwellhttps://www.umsl.edu/~alexanderjm/SupermanandMebyAlexie.pdf Supermen and me, Alexiehttps://wr.english.fsu.edu/sites/g/files/upcbnu1141/files/media/files/college_composition/inkwell/course%20materials/in%20th%20kitchen.pdf In the kitchen, Grate
what society has played role on individual’s choice and behavior?
South University Online Diversity in Law Enforcement Agencies Discussion
online dissertation writing South University Online Diversity in Law Enforcement Agencies Discussion.
400-600 word thread answering the Discussion Board question assigned from the readings. Threads require a minimum of 3 properly formatted citations. 1 being a Biblical reference. Topic: Increasing the minority applicant poolWhy is it important for law enforcement agencies to have a diverse work force?What are benefits from having a diverse police presence?What are intentional actions that police leaders can take to increase minority applicants?What are the organizational culture issues that need to be resolved prior to having a truly diverse force?250–400-word reply to 2 classmate’s threads. Each reply requires a minimum of 1 properly formatted citation. Each reply must be completed by you, the individual student. Additionally, each thread and reply must reflect a solid Christian Worldview through the use of at least 1 Holy Bible reference.Responding to a classmate’s thread requires both the addition of new ideas and analysis. A particular point made by the classmate must be addressed and built upon by your analysis in order to move the conversation forward. Thus, the reply is a rigorous assignment that requires you to build upon the thread to develop deeper and more thorough discussion of the ideas introduced. As such, replies that merely affirm, restate, or unprofessionally quarrel with the previous thread(s) and fail to make a valuable, substantive contribution to the discussion will receive appropriate point deductions
South University Online Diversity in Law Enforcement Agencies Discussion
It needs to be a research paper over split personality disorders. It must be written in APA 7th addition
It needs to be a research paper over split personality disorders. It must be written in APA 7th addition format. Every paraphrase or direct quote must be cited. Must have reliable/ database sources (google scholor). This is the order that my professor game me: “what is the disorder, symptomology, typical age of onset, incidence/ prevalence, treatments available, how does it affect the individual/family/friends/society. It needs to be written either over a subject or a movie.
Religious Studies homework help
Religious Studies homework help. Please incorprate the references used here tooModule 4 – CaseDuty EthicsAssignment OverviewIn the Module 4 Case, you will be applying duty ethics to the Mattel case.Required ReadingSethi, S., Veral, E., Shapiro, H., & Emelianova, O. (2011). Mattel, Inc.: Global manufacturing principles (GMP) – A life-cycle analysis of a company-based code of conduct in the toy industry. Journal of Business Ethics, 99(4), 483-517. Retrieved from ProQuest.Case AssignmentIn a well-written, 4- page paper (not including cover and reference pages), apply Duty Ethics to the Mattel case study.1.ÿÿ Briefly (1-2 paragraphs) describe what is meant by duty ethics (Duty-based ethics. (2014). BBC. Retrieved from http://www.bbc.co.uk/ethics/introduction/duty_1.shtml ).2.ÿÿ Choose two ethical issues raised by the Mattel case (e.g., Mattel?s treatment of company employees would be a good choice of ethical issues).3.ÿÿ Apply duty ethics to your two Step 2 choices. How does use of duty ethics as a lens inform the ethical nature of your two choices? Remember that duty ethics concerns duty and rights, so be sure to address both in your written analysis.4.ÿÿ Be sure to include at least two sources from the library to support your discussion and analysis.ÿ5.ÿÿ Be sure that you properly cite your sources using proper APA style, and use proper in-text citations.6.ÿÿ Follow the guidelines in The Student Guide to Writing a High Quality Academic Paper7.ÿÿ You are expected to demonstrate evidence of critical thinking ? as defined in the Module 2 background materials and the grading rubric.Module 4 – SLPDuty EthicsCSRBy now, you should be very familiar with the Mattel case. In the Module 4 SLP, we will evaluate the Mattel case study in the context of Corporate Social Responsibility. Specifically, socially responsible organizations behave in certain ethical ways. Socially responsible organizations tend to go above and beyond the rules, mores, and expectations that have been established (and that are expected to be adhered to) by the general public, company employees, end customers, buyers and suppliers, and the government, for example. We will investigate the ways in which Mattel?s behaviors and actions contravened the tenets of ?socially responsible? behavior. ÿRequired ReadingRead the following excerpt related to CSR. As you read, consider the benefits realized by socially responsible organizations, and how the leadership at Mattel operated counter to CSR tenets:Corporate social responsibility. (2013). International Institute for Sustainable Development. Retrieved from https://www.iisd.org/business/issues/sr.aspxAssignmentIn a well-written, 2- page paper, discuss how the Mattel case informs our understanding of what it means for companies to be ?socially responsible.?Keys to the Assignment1.ÿÿ In the context of CSR, in what ways did Mattel demonstrate ? not social responsibility ? but social irresponsibility? Consider how the company?s actions may have run counter to the tenets of CSR through its neglect of duty to the company?s shareholders, its employees, and even the larger public trust. Be sure to cite specific examples.2.ÿÿ What have been the long-term consequences of Mattel?s actions, and how did the company?s implosion change our view of what it means for a company to be ?socially responsible??3.ÿÿ Be sure that you use at least two references from the library, and that you properly cite your sources.4.ÿÿ Follow the guidelines in The Student Guide to Writing a High Quality Academic Paper5.ÿÿ You are expected to demonstrate evidence of critical thinking ? as defined in the Module 2 background materials and the grading rubric..1.ÿÿ Choose two ethical issues raised by the Mattel case (e.g., Mattel?s treatment of company employees would be a good choice of ethical issues).2.ÿÿ Apply duty ethics to your two Step 2 choices. How does use of duty ethics as a lens inform the ethical nature of your two choices? Remember that duty ethics concerns duty and rights, so be sure to address both in your written analysis.3.ÿÿ Be sure to include at least two sources from the library to support your discussion and analysis.ÿ4.ÿÿ Be sure that you properly cite your sources using proper APA style, and use proper in-text citations.5.ÿÿ Follow the guidelines in The Student Guide to Writing a High Quality Academic Paper6.ÿÿ You are expected to demonstrate evidence of critical thinking ? as defined in the Module 2 background materials and the grading rubric.Religious Studies homework help