Assignment 3: Incident Response (IR) Strategic DecisionsDue Week 6 and worth 75 pointsSuppose that you have been alerted of a potential incident involving a suspected worm spreading via buffer overflow techniques, compromising Microsoft IIS Web servers. As the IR Team leader, it is your responsibility to determine the next steps.Write a two to three (2-3) page paper in which you:Explain in detail the initial steps that would need to be made by you and the IR team in order to respond to this potential incident.Construct a process-flow diagram that illustrates the process of determining the incident containment strategy that would be used in this scenario, and identify which containment strategy would be appropriate in this case, through the use of graphical tools in Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.Construct a process flow diagram to illustrate the process(es) for determining if / when notification of the incident should be relayed to upper management, and explain how those communications should be structured and relayed through the use of graphical tools in Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.Detail the incident recovery processes for the resolution of this incident.Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources. Your assignment must follow these formatting requirements:Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.The specific course learning outcomes associated with this assignment are:Summarize the various types of disasters, response and recovery methods.Develop techniques for different disaster scenarios. Use technology and information resources to research issues in disaster recovery.Write clearly and concisely about disaster recovery topics using proper writing mechanics and technical style conventions.

This week, you will develop a database for a fictitious small school for its management of student records. You will also be required to write SQL statements to answer a few questions. Your instructor is the product owner. Post questions for approval before making any assumptions.The business description is outlined in Section 8.1 of your textbook. Your tasks include the following:Write business rules based on the given business description in an MS Word file named Item1.Draw a logical ERD that follows the business rules. Save the drawing in a jpg, png, docx, or pdf file. Name the file Item2.Map the logical ERD to relations by using the relational schema format. An example of a relation in relational schema format is:Student (StudentId, FirstName, LastName, MiddleInitial, AdvisorId)Use bold to indicate PK and italic to indicate FK. Use both bold and italic to indicate a field that is both PK and FK. Save the relational schema in an MS Word file named Item3.Complete physical design by writing T-SQL code to generate the database and tables. Save the SQL file with SQL file extension and named Item4.sql. This file must include all code to create the database with schema and tables in just one click to run. It must include the drop database line as shown in the book.Answer all six questions outlined in Section 8.8 of your textbook. Save all six SQL statements in one SQL file with the name of Item5.sql.Put all the above five files (do not combine files) in a zipped folder titled CaseStudy and attach it here.

Annotation is a crucial component of good data visualization. It can turn a boring graphic into an interesting and insightful way to convey information. This week, please navigate to any site and find a graphic that could use some annotation work. Add the graphic and the website it is found as an attachment to this post and note what you would do to enhance the graphic and note why you would make these decisions.