Before you begin read the following articles: The Mirai botnet explained: How teen scammers and CCTV cameras almost brought down the internet 19 Mirai Botnet Authors Avoid Jail Time You have been asked to provide a short presentation for Business Leaders Round Table meeting in your community. The topic of the meeting is Emerging Cybersecurity Threats and What Businesses Need to Know. Your presentation will be part of a series of talks about the risks associated with unsecured cyber-physical systems. The organizers have asked you to begin by presenting an overview of the Mirai Botnet attacks followed by a discussion of threats and vulnerabilities which have been found in cyber-physical systems used to manage buildings and utilities. For this briefing, you will need to find and use three additional authoritative sources that provide information about threats, attacks, and vulnerabilities affecting cyber-physical systems.

Part 1Referring back to your Reading and any other resources you have found, write a 2-page descriptive paper that addresses the following:What is the cloud?What are at least three potential benefits of the cloud?How can virtual environments reduce the need for new hardware?Would virtualization technology be beneficial to start with versus cloud resources? Why or why not?How would you respond to your manager from the scenario above?Make sure your paper covers the following topics:Infrastructure-as-a-Service (IaaS)Platform-as-a-Service (PaaS)Software-as-a-Service (SaaS)Virtualization technologiesBe sure to also include the following within your submission:Screenshots demonstrating experience installing and configuring a virtual environment. Part 2Explore Data Manipulation Language (DML) statements to manage data within schema objects.In business, things change, and data in an organization’s database must be modified to reflect those changes. In this module assessment, you will insert new data into the Northwind database, and you will then update a table in the database.You are also asked to develop SQL DML statements to retrieve data addressing several business inquiries. You must use the Northwind database for this assessment.Assessment InstructionsYou 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 SSMSThe module assessment consists of two tasks, and you will generate a Microsoft Word report from the completed work. You will use the Northwind database for both tasks. Deploy the Northwind database into your Microsoft SQL Server instance by executing the following script in a Microsoft SQL Server Management Studio (SSMS) query window:Northwind Database Deployment ScriptIt is very important that you watch the module videos associated with DML 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 - Developing SQL Statements to Query Existing DataOnce 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 task completion.Problem 1: Display the product records with unit prices equal to or greater than $100.Expected OutputProblem 2: Present the unit value minimum, maximum, average, and standard deviation for current and discontinued products. Group the results based on the “Discontinued” attribute.Expected OutputProblem 3: List suppliers with names starting with “G” in alphabetical order.Expected OutputProblem 4: Display the full names of all Employees in FirstName, “ ” , LastName format.Expected OutputProblem 5: Display all of the supplier names and HomePage values where the HomePage value is null. Present the results in alphabetical order by supplier name.Expected OutputProblem 6: Get the number of Northwind customers in each country that has five or more customers. Present the results in alphabetical order by country name.Expected OutputProblem 7: Get the total product costs (i.e., multiplying the unit price by quantity) for ProductID = 20 along with the associated orders IDs from the OrderDetails table. Provide the results in ascending order based on the order ID.Expected OutputProblem 8: Select all of the cities where there are employees with no duplicates values displayed. Show the cities in alphabetical order.Expected OutputProblem 9: List first and last names for employees who live in London, Seattle, or Redmond. Show the employee’s city in the output.Expected OutputProblem 10: Display all product IDs and names for out-of-stock products having a unit price in the range of $20 to $25. Show the units-in-stock value in the results.Expected OutputTask 2 - Modifying Database DataYou will use the Northwind database for this task. Leverage the following database design diagram as a guide in forming your DML statements for the problems specified below:Northwind Database Design DiagramYour assessment report needs to show both the generated SQL statements and confirmatory screenshots verifying task completion.Problem 1: Use an SQL INSERT statement to populate the Categories table with a new category called “Fresh Produce” and a description of “Fresh Fruits and Vegetables.” There is no picture for this record insert. Remember, the CategoryID field auto populates so you do not include this in your insert statement. After you have added the category, select all records in the Categories table to see if the record was added.Expected OutputProblem 2: Use the SQL INSERT command to add a new region to handle customers in the Midwest. In this case, the RegionID field does not auto populate so you should first find how many regions are in the table before adding the new region and RegionID. Use a query after completing this to verify that the new region has been added.Expected OutputProblem 3: Northwind has decided to change the employee title that is now called “Sales Representative” to “Sales Specialist.” Use the SQL UPDATE statement to reflect the change in the Employees table. After you have updated the Employees table, select all records in the Employees table to see if the update was performed correctly.Expected OutputProblem 4: The Sales department has realigned and before they implement the new “Midwest” region you added, they noted that it really should be called the “Southeast” region. Change the “Midwest” region name to “Southeast” and show the regions again to confirm this change.Expected OutputProblem 5: An order needs to be deleted. The order number is 11071. However, before you can delete the order, you must delete the order details. Delete all records in the OrderDetails table that references order number 11071. Then execute a query against the OrderDetails table to show that the records associated with order number 11071 have been removed.Expected OutputProblem 6: Delete order number 11071 from the Orders table. Then execute a query against the Orders table to show that the record was removed.Expected OutputProblem 7: An employee named Margaret Peacock just received a 5% raise from Northwind. Update Ms. Peacock’s employee record to reflect this change. In order to do this, her current salary needs to be multiplied by 1.05 in the update statement.Expected OutputProblem 8: A new supplier needs to be added to the Northwind database. Generate an SQL statement to insert the following details:Company Name: Acme EnterprisesContact Name: Wylie CoyoteContact Title: Executive ManagerAddress: 123 Main StreetCity: Las VegasRegion: NVPostal Code: 89108Country: USAPhone: (702) 555-9876Note: You do not need to provide a SupplierID for this record.Expected OutputProblem 9: A customer just purchased 40 units of a product called “Boston Crab Meat” from Northwind. Reduce the current UnitsInStock value in the Products table by 40 for this product.Expected OutputProblem 10: A final call has come in from the Sales Department. After presenting the new regional alignment to the board, the board has rejected this part of the reorganization plan. Please DELETE that new region that was added earlier in Problem 2 and then changed in Problem 4 of this assessment task.Expected Output

Please read the Scotiabank case study (see HBS Coursepack) and answer the following questions with substantive answers in a cohesive essay. 1. What are the success factors in the Scotiabank-Kabbage partnership? 2. Under what conditions is the same model applicable?When will the Scotiabank-Kabbage model not work? 3. Under what circumstances should Scotiabank seek fintech partnerships? 4. Identify a sector (e.g., international payments, blockchain, lending or wealth management) and a geographic market where a fintech partnership would create value for Scotiabank, and explain why. 5.Based on your answer to question 4, what recommendations would you make to Scotiabank's executives for a three-year plan, choice of partner, reason for the partnership, and suggested procedure (i.e.,what partnership model to follow)? 6. What challengers is Scotiabank facing in the blockchain sector? What are the implications for the bank's blockchain partnership strategy? .