IntroductionNetwork defenses rely first on understanding the current configuration of hosts, services, and protocols in use within the organization. Before it is possible to plan to change anything, you must first understand what is present and where it is located within the network. The initial phase of any network security realignment process involves identifying existing resources. Scenario You have been working as a technology associate in the information systems department at Corporation Techs. The Corporation Techs’ management is concerned that they are losing business to a competitor whose bids are too accurately just under the bids offered by Corporation Techs––by an exact amount. A security firm was contracted to conduct a review of Corporation Techs' systems, identifying unauthorized access to the Web server as a potential source of compromise due to the shared reporting and public Web site functions. The packet trace and vulnerability scans gathered during this review are available for your use. The Web server provides public access to the organization's static Web site for contact information, while sales team members in the field transfer contract and bid documents using a site secured with a logon and password. Corporation Techs has budgeted for new networking hardware but does not want to add additional servers due to cooling issues. Your manager has asked you to create a security plan that will prevent unauthorized access, while making sure that both public and secured Web access remain available. Tasks The data and information you need to complete this part of the project are provided in the Project Files folder. In this part of the project, you need to conduct a survey of the existing hosts, services, and protocols within Corporation Techs' network. Specifically, you need to: Access the PCAP data using NetWitness Investigator or Wireshark. Identify hosts within the Corporation Techs’ network. Identify protocols in use within the Corporation Techs’ network. Develop a list of hosts and services provided by each. Create a spreadsheet identifying the information above to help you design a network in the next section.Submit spreadsheet outlining the network survey results as detailed in the instructions above.

QGIS is a free GIS application available across all Operating systems (MacOS, Linux, Windows). Like all GIS tools, it has its ups and downs. Being a free, well supported, and a constantly evolving suite of software is a huge upside. Unfortunately, the layout is a little complex to get used to especially if you are already well versed in ArcGIS. QGIS is not a requirement for this course, you are more than welcome to use ArcGIS to complete the assignments throughout this course. However, all maps will be required to have a legend, compass, scale bar, title, etc. Without these elements, a map is not of any value to the user.I do encourage you to read these QGIS tutorials and try to get accustomed to using this free tool. Why? Because once you graduate you may not have access to ArcGIS. True, many businesses and universities subscribe to the Arc Suite, however, Arc is extremely expensive and not always available as a GIS tool. Understanding the use of multiple GIS software can provide a huge advantage to you in the future. Download the sample imagery and produce a map with the appropriate map elements. This image is around 400mb, so allow yourself time to download, open, and extract it. It is also already georeferenced with GPS coordinates so adding a map scale will be very straight forward.

Now that you have defined your E-R model and project description in the project you started and worked on inWeeks 1 and 2, start converting your logical E-R model to a physical model.In this week, complete the following tasks:In a Microsoft Excel spreadsheet, define columns with the following headings:Primary KeyName of ColumnNull (NorY)DatatypeDescriptionForeign KeyForeign Key TableEach row will contain your rows for this table.Fill out the columns row-wise.Using Microsoft Visio or Microsoft Paint, create an E-R model of the six tables from your spreadsheet for developing the business requirements and constraints that will maintain the business logic for your database.The E-R model should be readable and should map to the spreadsheet and the project description.It should have all the cardinality and optionality defined.