Cisco Network Proposal (Parts 1-3) You have been recently hired as a network administrator for the xAcme Technology Trade School. The school realizes that the local systems administrators need help implementing certain technologies at each of the remote locations, as well as final WAN configurations. Out of the network administrators on staff, you have been asked to move the Cisco Network Proposal forward. With your background and skills, you will design, implement, and assist in configurations to support xAcme’s topology. Technologies to implement will differ from site to site, as administrators have begun topology implementations. You will be provided the overall topology as well as certain device configurations in order to determine the best course of action per site/challenge. In addition to helping the school configure its network, xAcme requires that all new network administrators obtain their CCNA certification within 60 days of being hired. You are excited about starting this project but realize creating a schedule to help balance your work and home life will be the key to success. Your proposal will be submitted in three major parts: Springfield Device and STP Configurations (i.e., Part 1)Worchester Subnetting Configurations and Boston Site Protocol, Route Summarization, and Topology Improvement (i.e., Part 2)Sacramento Site VLAN, Routing on a Stick (ROS) and DHCP Implementation, Los Angeles Site Management Technologies, xACME WAN - WAN Implementation and Security Communications (i.e., Part 3) The details for each of these Part (i.e., Part 1, 2, and 3) can be found below. Each of these parts will be submitted to the LEO Assignments folders and TurnItIn. Each of these parts should be submitted independently of the other parts. Along with the challenges presented in this document, you will be provided an overall site topology to work from, as well as specific device configurations (where applicable) to make your recommendations. Suggested solutions should be comprehensive and justified in approach. Configurations of technologies should be written out to help guide the systems administrators with implementation. In some cases, you may find it necessary to implement additional cabling, which can be done by adding to the supplied topology. Any adjustments to the sites’ topology that you find necessary should be documented and supplied with your submission. Your document will be divided up by site and solutions per site. Each area is unique in requirements but collectively will demonstrate your understanding of network routing and switching technologies. Each scenario will provide you with suggested sections within TestOut (LabSim) to use as a guide in your analysis and recommendations. To learn how you will be assessed on this assignment, take a moment to review the rubric. The final deliverable should adhere to the following criteria: Use this template as a guide while creating your Cisco Network Proposal (Parts 1-3).Include at least two scholarly references in each of the three submissions. Thus, a total of six scholarly references will be included in total. Students may find scholarly sources by visiting UMUC’s library and online sources. Students will also include other credible sources as appropriate.Use IEEE citation style. We do not use APA or MLA-style citations. Students should contact UMUC’s Effective Writing Center for assistance.Use proper terminology and expand acronyms in each paragraph they are used. For example, the first time in a paragraph an acronym is used it should be expanded (e.g., University of Maryland University College (UMUC). Thereafter, and as long as you are in the same paragraph, the acronym (e.g., UMUC) can be used. When starting a new paragraph, the rule begins anew.The use of figures and diagrams is encouraged. Students will properly cite the figures and diagrams according to the IEEE citation style. Existing VLANs - Remote locations vary in terms of size and requirements. Some implementations will require current site router/switch-running configurations, which will be provided. All sites will use the following four VLANs, but you will need to configure only what is asked per site (some assumptions will be made). Existing VLANs, per xACME:Faculty VLANused by faculty on-site for all office locations (non-instructional communications)total devices per site will varyAdministrative VLANused by staff on-site for business administrative communicationstotal devices per site will varyAcademic VLANused by faculty and students for classroom labs and instructional communicationstotal devices per site will varyServer VLANused by IT staff for all technology/management communicationstotal devices per site will vary The types of devices per site will be the same; however, the number of deployed devices may vary (all documented in the xAcme educational topology). Routers Per Site: Cisco 2800 Series Integrated Services Interfaces Ports Available 4 Fast Ethernet Interfaces (Per Router) 2 Serial Interfaces (Per Router) fa0/0 s0/0/0 fa0/1 s0/0/1 fa1/0 fa1/1 Switches Per Site: Cisco Catalyst 6500 Series Ports Available 96 Total Gigabit Ethernet Ports Per Switch Module 1 = gi0/1 - gi0/24 Module 2 = gi1/1 - gi1/24 Module 3 = gi2/1 - gi2/24 Module 4 = gi3/1 - gi3/24 Note: Device type will not impact your configuration commands and implementation of ALL required technologies will use Cisco IOS commands/concepts learned in our TestOut lecture(s). Standard switchports will be configured and used as trunk OR access ports, and DCE ends should be noted when configuring serial ports per router. Click here to download the configuration file for all of the devices. Note: one of the files in the zip file is a Packet Tracer file. You can open it using the Packet Tracer program that you can download from here. The use of Packet Tracer is optional. Springfield Site Device and STP Configurations (Focus on the Springfield Site Only) - Required Implementation: Device hostnames, banners, secured passwords and spanning tree protocol. Device Configurations: Implement device hostnames to match the xACME educational topology labels. Provide a template and sample configuration for the MOTD banner and login banner (wording and implementation) for one of the switches. Keep this generic, as it will be implemented on all switches in the xACME educational topology. Lastly, include the configuration steps for implementing device passwords on both console port (out-of-band communications) and VTY (Telnet/in-band communications). All passwords should be encrypted.Spanning Tree Protocol (STP): Briefly explain the advantages and purpose of the STP. Administrators are having a difficult time placing switch 1 as the root. Provide a sample configuration for implementing SPT on the switches. Choose the mode you feel would be best suited for the environment and justify why. Switch 1 will need to be the root switch in the Springfield topology. Consider any security measures that can be implemented to protect the devices from bogus BPDUs. Note: When approaching the spanning tree challenge, do not concern yourself with the multiple VLANs at this time. Focus simply on the default VLAN1, which is the active VLAN that all ports belong to in this topology at this time. Please refer to the following configurations:SpringfieldSw1SpringfieldSw2SpringfieldSw3SpringfieldSw4 Worchester Site Device and STP Configurations (Focus on the Worchester Site Only) - Required Implementation: Subnet addressing to accommodate Worchester site Subnetting: Properly subnet addressing blocks to accommodate the site's VLAN sizes. You will not need to implement VLANs here; rather, you will create the correct sizing to properly accommodate the devices stated per the xACME educational topology. Carefully consider the challenges faced when structuring subnets too large and/or too small during your design. The starting Worchester site addressing range is 10.20.0.0 /16 (per the xACME educational topology diagram). Formatting per subnet should follow the format below and should be clearly stated and placed within a table. NetIDmask/CIDR valuesbroadcastusable range No additional device configurations required to complete Boston Site Routing Protocol, Route Summarization and Topology Improvements (Focus on the Boston Site Only) - Required Implementation: Implement a routing protocol to manage networks within the Boston site topology as well as default routes to exit non-Boston traffic. Summarization addresses should be stated per router in Boston’s topology. Consider redundancy upgrades as well and document per topology. Routing Protocol: Research the different routing protocol types (distance vector/link state/hybrid) and choose a routing protocol implement (OSPF, EIGRP, RIP). Justify your selection by defining its strengths and weaknesses. Define the proper addressing block to assign per point-to-point links and implement your solution per all three routers. Routing protocol should be set up in a way to advertise all IP subnets, WAN, and LAN interfaces on a router. Be sure to protect the advertisements of the routing tables as well.Summarization: Define the route summarization addresses for each Boston site router. These addresses will not be implemented on the routers, but they will be documented in your response. Each summarization address must be large enough to include all required subnets contained within the underlying site subnets.Default Route: Any traffic not matching internal networks will need to be routed outward. Implement default routes on the site routers to exit this traffic.Topology: Consider the potential challenges with the current Boston site topology (cabling and redundancy approach). If improvements are needed, update the topology and discuss and routing redundancy approaches you see fit. Please refer to the following configurations:BostonSiteRouter1BostonSiteRouter2BostonSiteRouter3 Sacramento Site VLAN, Routing on a Stick (ROS) and DHCP Implementation (Focus on the Sacramento Site Only) - Required Implementation: VLANs, ROS, and DHCP implementation VLANs: Implement the VLAN database on the Sacramento site switches. Explain the assignment of switchport modes and how to implement each. Demonstrate how to implement port security on the switchports to allow only two MAC addresses per port and shutdowns for violations. Additionally, consider proper security management of any unused ports.ROS: The site will be treated as a routing on a stick (ROS) topology. Provide a sample configuration for Sacramento fa0/0 interface to support the multiple VLANs and inter-VLAN routing.To simplify configuration, please use the following addressing:faculty VLAN: 10.50.0.0 /26administrative VLAN: 10.50.0.64 /26instructional VLAN: 10.50.0.128 /26server VLAN: 10.50.0.192 /26DHCP: The site will need a solution to manage the deployment of IP addresses. Briefly explain the purpose of DHCP and provide implementation of the DHCP configuration for the VLANs. Be sure to include the pool name, exclude the last 10 addresses of each subnet range and configure the gateway, subnet mask, and DNS address (Sacramento fa0/0 address). Please refer to the following configurations:SacramentoSw1SacramentoSw2SacramentoSw3SacramentoRouter Los Angeles Site Management Technologies (Focus on the Los Angeles Site Only) - Required Implementation: Device configuration remote storage, remote management of switches, ACL implementation, and an NTP solution. Remote IOS Storage: The site will require remote storage of the devices' configurations. Server details are provided per your topology. You will determine the protocol to use and demonstrate how to implement the solution.Remote Management of Switches: All devices will be configured to allow for remote management. You will be required to implement this solution on the switches found on the site.ACL Implementation: In order to restrict and protect access to the devices, the only VLAN allowed to communicate remotely with the devices should belong to the server VLAN. Determine the type of ACL to implement and the placement of the list and implement the solution on the site router.Network Time Protocol: Implement an NTP solution on the devices found within this topology to ensure clock synchronization is accomplished. The purpose would be for accurate logging records and authentication protocols. Server details are provided per your topology. Please refer to the following configurations:LosAngelesSw1LosAngelesSw2LosAngelesSw3LosAngelesRouter xACME WAN – WAN Implementation and Secure Communications (Focus on All Site Entry Point Routers) - Required Implementation: WAN Implementation, device authentication, and topology suggestions. WAN Implementation: Current WAN links are serial-based and connected over leased lines that are using the Cisco default protocol for layer 2 connectivity. Authentication is not present at this time, but the added security would be preferred. Research the available WAN protocols and suggest a solution to provide authentication between devices. Implement basic routing protocol authentication. Provide a sample implementation over serial links for your systems administrator to follow. Included in this task are device configurations for the current implementation.Topology: Currently, the Los Angeles and Boston sites are connected across leased lines, and each remains as the entry point to its respective regional locations. There is growing concern over the amount of traffic both devices are handling. Review the xAMCE educational topology and make recommendations to provide some redundancy among sites, as well as to alleviate some of the bandwidth requirements placed on both devices. This may require additional lines to be leased. With your suggested improvements, update the topology as you see fit. Note: Additional addressing is available if needed. Simply create the additional ranges from the provided available xACME public address range, 165.128.63.0 /26. Please refer to the following configurations:BostonSiteRouter1WorchesterRouter Cisco Network Proposal Template CMIT 350 WAN and SOHO Skills Implementation Use this document as a guide for formatting and organizing your CMIT 350 Skills Implementation challenge. Title Page Professionalism will be key to your success and advancement in your academic and professional career. Use the title page to identify relevant information such as your name, the course, professor, and submission/completion date. Document Index/Contents Organization will allow your document to be divided into key areas of consideration and allows an overall structure to be placed over the submission. Sample text: Site “XXXXXXXX” Challenges and ImplementationSite “XXXXXXXX” Challenges and ImplementationSite “XXXXXXXX” Challenges and ImplementationBibliography I.Site “XXXXXXXXXX” Challenge and Implementation (Provide a section for each site, as suggested in your table of contents.) Site Details and Challenges (Summary) Here, you will simply summarize the site requirements and/or challenges you are attempting to overcome. You will not need to implement solutions or discuss your approach at this point. This information is provided to you and can simply be organized and restated as you understand it. Think of this area as what needs to be corrected. Suggested length would be one or two paragraphs. Sample text: As described in the scenario, the xUMUC site was developed without any VLAN structure, and administrators have found the need to isolate broadcast traffic from a layer-2 perspective. Site Solution(s) and Technologies With the challenges stated, you will be able to clearly define your approach to solving those challenges and can state the technologies you will be implementing. Be sure to use this area to justify your approach and selection of technologies as well. The specific length and details of this area will vary based on the specifics and depth of the challenge you are facing. Your justification would be your selection of a specific technology or approach over another and why you chose the approach you are taking. Show off your knowledge in the foundational skills here! Sample text: In order to relieve the administrative tasks surrounding the implementation of manual IP addressing per device, we will configure and implement a DHCP (dynamic host configuration protocol) server, per site requirements. The DHCP allows for devices to identify, request and implement IP configurations as well as other settings…. Since this area may call for facts and details around technologies and approaches, you will most likely find yourself using in-text citations, which would appear as follows: Open Shortest Path First is an open standard routing protocol that’s been implemented by a wide variety of network vendors, including Cisco [1]. Sample Configuration Understanding the technologies will satisfy a portion of the documents' requirements. You will also need to display how the solutions you are suggesting would be implemented. This will include the specific commands used to configure the devices. Instructions will state when sample configurations are required, and any sample configurations should be limited to the devices provided, per the site topology. Device syntax to be used can be found in your training suite, TestOut’s LabSim. Show off your technical competency here! Sample text: Sample Device Configuration 1 Supporting Tables/Diagrams When structuring solutions per certain sites, you may find it helpful or even necessary to structure information with tables and/or diagrams. These items can be used to support and display your understood solutions located in the “Site Solution(s) and Technologies” area. Display your organizational and logical skills in this area! Sample table: Sample Table 1 Sample Table 2 Sample Diagram 1 Repeat the format to include document components for each site. In this sample, sections numbered II and III in your table of contents would be provided next, followed by the bibliography. IV.Bibliography Be responsible with your research and included works. Provide proper credit in the IEEE format to original authors and their works that you leverage in your submission. Sample Entry: [1]T. Lammle. CCNA Routing and Switching Study Guide. Indianapolis, ID: Sybex Wiley, 2013, p. 386. This is how the Instructor want each proposal written. Cisco Network Proposal (Part 1) Course: CMIT350 Prof: Written by: Date: 01/28/2018 Summary: Springfield Site Device and STP ConfigurationsBibliography Site Details and Challenges (Site Spring Challenge and Implementation): I am about to build up the network of Springfield site to determine the sources of their implementation. This site includes of 4 Cisco Catalyst 6500 Series switches Springfield – Switch 1, Springfield – Switch 2, Springfield – Switch 3, Springfield – Switch 4, 2800 Series Cisco router and 4 VLAN. I can suggest also a total of 324 devices which can be connection through the 4 VLAN. In this assignment, all network developments and configurations have been divided per site with the sample table and snapshot. Site Solutions and Technologies Device Configuration Hostnames: Hostname commands are used to hold specific name that a user want to define. It can take maximum 63 alphabets. If a user wants to go through more than one session, this hostname configuration can make it easier to work with. It also gives a method for tracking the last destination of each session.Banners: Secured Passwords: To protect from unpermitted and unauthorized usage, this secure password configuration is used. It helps to detect the ethical connection and restrict from unusual activities. Hostname Configuration Switch>en Switch#conf t Switch(config)#hostname SpringfieldSw1 SpringfieldSw1(config)#exit SpringfieldSw1#copy run start Enter and exit. For the leftover switches, same command can be used in every configuration. For example, Sw2 or Sw3 or Sw4 instead of Sw1. This function configures a message of a day which is called MOTD and login banner. It will help the users to maintain proper device usage with appropriate disclosure statement. Because it works through the warns and restrictions messages which are displayed to the users. Configuration: SpringfieldSw1>en SpringfieldSw1#conf t SpringfieldSw1 (config)#banner motd # User is logging to the xACME. # SpringfieldSw1 (config)#banner login # Only Authorized Personnel and all the activities are being recored. # SpringfieldSw1(config)#exit SpringfieldSw1#copy run start Enter and exit. Configuration: SpringfieldSw1>en SpringfieldSw1#conf t SpringfieldSw1#en secret xACMEcon01 SpringfieldSw1(config)#line con 0 SpringfieldSw1(line)#line VTY 0 4 SpringfieldSw1(line)#password xACMEvty01 SpringfieldSw1(line)#login SpringfieldSw1(line)#exit SpringfieldSw1(line)#copy run start enter and exit. Spanning Tree Protocol: The Spanning Tree Protocol is a network protocol that provides the logical loop-free topology for LAN (Local Area Network). The primary function is to keep the prevention of bridge loops and the broadcast storms that generates from loops. The main advantage of STP is to maintain network with more than one switch implementing clear ways with the devices for the usage of fault tolerance. Those loops recover directly from a topology change or device failure, and determines the optimal path between two network devices. One disadvantage of STP is that it seems slower when the topology changes. Therefore, its better to connect to the default gateway of network. Configuration: Springfield_SW1>en Springfield_SW1#conf t Springfield_SW1(config)#spanning-tree vlan 1 priority 4096 Springfield_SW1(config)#exit Springfiled_SW1#copy run start Enter and exit. Configure BPDU guard: SpringfieldSw1>en SpringfieldSw1#conf t SpringfieldSw1(config)#int fa0/1 SpringfieldSw1(config-if)#set spantree portfast 4/1 enable trunk SpringfieldSw1(config-if)#exit SpringfieldSw1(config)#exit SpringfiledSw1#copy run start Configure RPVST SpringfieldSw1>en SpringfieldSw1#conf t SpringfieldSw1(config)#spanning-tree mode rapid-pvst SpringfieldSw1(config)#exit SpringfiledSw1#copy run start Enter and exit Also, there are algorithm routing system which is based of control layer. It consists of satellite ground station through management function of network and operation control. This controller is called SDN controller and it is based on integration method. This system manages the operating, network security and controlling. Table: Springfield Site Network Location Interface IP address Subnet ID VLAN SpringfieldSw1 Gi0/1-2 192.168.72.1 255.255.255.0 Faculty VLAN SpringfieldSw2 Gi0/1-2 192.168.72.1 255.255.255.0 Server VLAN SpringfieldSw3 Fa0/1-2 192.18.72.3 255.255.255.0 ITadmin VLAN SpringfieldSw4 Fa0/24 168.98.23.2 255.255.255.0 Security VLAN Bibliography "Spanning Tree Facts 11.2", TestOut, 2018. [Online]. Available: https://cdn.testout.com/client-v5-1-10-486/startlabsim.html [Accessed Feb. 12 2018]"Understanding and Configuring Spanning Tree Protocol," Cisco, 17 08 2006. [Online]. Available: http://www.cisco.com/c/en/us/support/docs/lan-switching/spanning-tree-protocol/5234-5.html. [Accessed Feb. 12 2018]X. Yu, W. Lei, L. S, W. Zhang, “A Routing Algorithm Based on SDN for On-Board Switching Networks.”, Journal of Information Science & Engineering; Vol. 33, no 5, pp 1255-1266, Sept. 2017.

Can I get help on SQL query. All the questions and requirements are in the attacked files. I also attached the sample input and output.