Supernetting and IP AddressingA corporation is in need of setting up a new network which requires four subnets of 250 IP addresses which are required to aggregate into a single supernet.Based on your understanding of networking concepts, create a report in a Microsoft Word document answering the following:What class of IP address should you assign to the subnets and to the supernet into this new network and why?Discuss in detail with references cited as to the range of 0 to 255 with regard to port numbers.Discuss any standards that are in place today for port ranges 256 to 1024. Explain and describe established standards for use of port numbers.Assume a bank in Seattle, WA has been well established for some time. The company has five branch offices and its own company web site and mail server. The bank wants to expand by adding more branches and to deploy several systems with public IP addresses. Their Internet provider handles the DNS needs of the bank but they now want to bring this function in-house to manage it themselves.Enlist the correct number of DNS servers that would be needed?Discuss the proper routing required to get the requests to the DNS servers.List all the steps of the message exchange between the DHCP and the computers on a different network.

Individual Project 4Unit: Techniques Used in Database AdministrationDue Date: Wed,12/16/20Grading Type: NumericPoints Possible: 150Points Earned: Points Earnednot availableDeliverable Length: Word document of 4–5 pages (excluding references and cover page)View objectives for this assignmentGo To:Assignment DetailsScenarioLearning MaterialsReading AssignmentMy Work:Online Deliverables: SubmissionsLooking for tutoring? Go to SmarthinkingAssignment DetailsAssignment DescriptionKey Assignment DraftThe case study retail store is concerned about the possibilities of losing data because of database system malfunctions or downtime. Security is also a major concern to the company because it is common knowledge that engaging in online business can be risky because of known vulnerabilities on the Internet. The company also realizes that its in-store database system is the top priority at this time. What solutions can you propose to effectively manage database transactions, maintain security, and recover the data that are lost from system failure or downtime?Examples are provided here to help with this assignment.The assumptions are as follows:A high volume of the orders often occurs during the daytime.One person will serve the role of database administrator.The database administrator account will serve as database owner.The transaction log must be backed up.Point-in-time recovery is required.There is an always-on availability group.The ability to purchase products online will be addressed in a future database project.The project deliverables are as follows:What solutions can you propose to effectively manage database transactions, maintain security, and recover the data that are lost from system failure or downtime?What is your rationale for the transaction management plan, database security procedure, backup plan, and recovery model that you proposed for the case study organization?Database Administration Plan (4–5 pages)Create a database administration plan that is specific to the needs of your retail store.Include a transaction management plan that includes a flowchart for how each transaction will be handled (including rollback and commit cases).Include a database security procedure that includes provisions for access control, user authentication, and availability.Include a backup plan and a recovery modelProvide your analysis as to how this part of the project fulfills the mission and 1 or more goals of the case study organization.All sources should be cited both in-text and in References using APA format.Name the document "yourname_CS660_IP4.doc."