PROJECT SUMMARY:You have been asked to submit a proposal to a client who has just bought a single-floor house. The proposal is on the analysis and design of the home network in the house. You, in preparing the proposal, must decide on the architecture, topology, and network hardware and software of the house’s new network.BACKGROUND:Your college friend, John Smith, just bought a single story house in Southern California. He intends for the home to have a state-of-the-art home network. Because Mr. Smith knows you personally, he asked you to submit a proposal on the network and all associated hardware and software. Knowing that you are an expert in networks, Mr. Smith is depending on you to analyze and design a network for his new home.HIGH LEVEL REQUIREMENTS:In speaking with Mr. Smith over lunch one day, you have gathered the following high-level requirements from him. These requirements are shown below in the form of quotes from Mr. SmithI want the house “wired with fast network”Get me “the fastest internet connection you can get”The living room, the study, and the bedrooms need to have wired network connections for computers/network devices.Mr. Smith recently bought a laptop. It is Dell XPS 15 Ultrabook with 7thGeneration Inetcore i9 processor; it also has a 4K Ultra HD (3840 x 2160) display and a 1.0 TB SSD (Costco, 2019). Mr. Smith uses the laptop for general business applications and web surfing. He does not play online games.The study needs to have “a networked color laser printer.”“The living room in the house should have a network-connected, high definition, flat-panel, LED TV” (50 Inch Tv)In the new home, there are one dining room,one study/library, one living room, one master bedroom, and one guest bedroom.Mr. Smith does not want to pay for TV (no cable TV or satellite TV). But he does want a TV that can connect to Netflix and Roku services.CONTENTS OF PROPOSAL REPORTYou have been asked to submit a proposal for building the home’s new network. Mr. Smith requires a network proposal that includes the following sections:1. Executive Summary: A description of the objectives of the proposal and a high-level summary of the report.2. Network Analysis: Described Below.3. Technology Design: Described Below.4. Cost Assessment: Described below5. Bibliographical Refrences: Described Below.NETWORK ANALYSIS SECTIONThe network analysis section consists of two subsections: Need Analysis subsection and Logical Network Diagram Subsection.Needs AnalysisThe needs analysis subsection basically contains the requirements of the network. You need to conduct a NEEDS ANALYSIS to come up with the specific requirements (i.e., more detailed than general requirements shown above) of the network. The Needs Analysis will look at:Needs and requirements of the user (John Smith)Various applications necessary to support those needs. For examples, Netflix is an application, printing is an application, and web surfing is an application.Data rate needed to support those applications.Needs Analysis must be detailed enough so that you can justify the solutions that you recommend in the proposal.After determining the needs, you then generate a logical network diagram.Logical Network DiagramThe logical network diagram subsection needs to include, at a minimum, the following:A logical network diagram of the network based on the network requirements (gathered as part of Needs Analysis)A description of the logical network diagram and how it’s different parts fir together to form a home network.A logical network diagram resembles “block diagram” of the network connected together. Examples are shown in Figure 1-1 Attached below. In the logical network diagram, each network block is labeled generically (e.g., “router”, “printer”, “TV”, etc) and no manufacturer name and model number needed on the diagram.Note that the logical network diagram would contain both LAN and wide-area network connection to the Internet. Discuss how you would connect the home’s LAN to the Internet.TECHNOLOGY DESIGN SECTIONTechnology design refines the logical network diagram generated and produces a physical design that will meet the requirements. The technology Design section consists primarily of Physical Design. In this report, you only have to produce a Preliminary Physical Design.The Preliminary Physical Design needs to include, at a minimum, the following:- Exact configuration of each piece of hardware (e.g., router, printer, TV, etc.) such as manufacture’s names and models, and brief description (in your own words with citations and references) of each piece.COST ASSESSMENT SECTIONAfter you have gathered the exact configuration (manufacturer’s name/model number) of each piece of hardware (and software), present a detailed cost estimate of the entire network. The cost assessment section should include a detailed cost assessment of the network. Including cable, hardware, software, and labor. (Assume that 300ft. of cable is needed for the home network.)Labor is an important component of cost, so include cost of labor required to install the network. Use a planning figure of $300/person-hour and estimate the cost of labor required to implement the network.In addition, include the ongoing, operational cost of the network (such as monthly Internet Service Provider free or any periodic maintenance cost) for three years. In other words, present both initial, fixed cost of the network and the ongoing, operational cost of operating the network. An explanation of different cost items is required.NotesAs with any real-life problem with ambiguities or unsolved considerations, you must make your own assumptions, but be sure to explicitly state any assumptions. Feel free to find materials that support your recommendations.BIBLIOGRAPHICAL REFERENCES SECTIONThis section will have a list of references used in the report. Note that in addition to references in this section, the report also needs to have specific in-text citations in the body of the report.PROPER CITATIONS AND REFERENCES:1. Be creative in presenting your planning and analysis. You should research, glean and include materials necessary to appropriately communicate and understanding of the system. You need to write the report in your own words and give proper credits to sources you use.2. If you quote a source word-for-word, do the following:Put a pair of quotation marks around the quoted sentence(s), And give the citation (author, date, and page number) in parenthesis directly in text right after the quoted sentence(s).Put the full reference at the end of the report under the references section.3. If you paraphrase a source, do the following:Give the citation (author and date) in parenthesis directly in the text right after the paraphrased sentence(s).Put the full reference at the end of the report under the References section.4. All references listed under the References section must be cited in the text. There should be no “orphan” reference in the References section.5.Remember: its not enough to simply include the full reference at the end of the report under the References section. YOU HAVE TO PROVIDE THE IN-TEXT CITATION DIRECTLY IN THE TEXT ALSO.WHAT TO DO:The report must be typed.The various diagrams must be drawn using software such as Visio. Visio is easier to use for drawing diagrams.Draw tour own diagrams, don’t copy them from manufatures’ website.Use the reference section to list all sources (online and in hardcopy form) or materials used.The length should be between 1,500 and 2,000 words (not counting the Reference section, tables, and figures).WHAT NOT TO DO:Do not clutter your report with unnecessary drawings and diagrams that do not add to the substance and clarity of the report.Do not blindly copy manufactures diagramsDo not plagiarize.

The purpose of this assignment is to use analytics techniques to analyze a case problem. Part 1Read Case Study Case 15.2 “Ebony Bath Soap” from the textbook, and then complete the following items.For Questions 1 and 2 of the case, use the Palisade DecisionTools Excel software to set up a simulation model and run a simulation with 500 trials for the case. Ensure that all Palisade software output is included in your files and that only one Excel file is open when running a simulation. Use the "Topic 3 Case Study Template" file as a starting point. Hint: The RiskSimtable function was be helpful for running the simulations.Respond to Question 3 as written in the problem. Ignore the confidence interval portion of the question.Respond to Question 4 as written in the problem.To receive full credit on the assignment, complete the following.Ensure that the Palisade software output is included with your submission.Ensure that Excel files include the associated cell functions and/or formulas if functions and/or formulas are used.Include a written response to all narrative questions presented in the problem by placing it in the associated Excel file.Include screenshots of all simulation distribution results for output variables.Place each problem in its own Excel file. Ensure that your first and last name are in your Excel file names. Part 2In a 500-750-word summary to company management, address the following. Include relevant charts and graphs within your summary, as needed.Describe the case specific business requirements and how they can be communicated across all levels of the organization.Based on the simulation results, discuss the Annual Cost output statistical distributions. Assume that your audience as minimal background in statistics.Discuss which Annual Cost output probability distribution has the most dispersion, and explain why this is so. Explain the descriptive, predictive, and prescriptive analytics that have been used to formulate the solutions to the business needs.Based on the Annual Cost output statistical distributions and other information gleaned from your analysis, discuss the specific prescribed course of action you would recommend to company management and justify your recommendations. Include discussion of how the proposed analytics solutions can optimize organizational performance and effectiveness.While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

OverviewRead the following articles and incorporate them into your paper. You are encouraged to review additional articles as well.Jeang-Kuo Chen. 2019. An Introduction of NoSQL Databases Based on Their Categories and Application Industries. Algorithms, vol. 12, no. 5, p. 106. https://doi.org/10.3390/a12050106Stefanos Georgiou. 2019. Software Development Lifecycle for Energy Efficiency: Techniques and Tools. ACM Computing Surveys, vol. 52, no. 4, pp. 1–33. https://doi.org/10.1145/3337773L. Mokokwe. 2018. First Things First: Adopting a Holistic, Needs-Driven Approach to Improving the Quality of Routinely Collected Data. Journal of Global Oncology, p. 155. https://doi.org/10.1200/jgo.18.68700Yulia Shichkina. 2019. Approaches to Speed Up Data Processing in Relational Databases. Procedia Computer Science, vol. 150, pp. 131–139.InstructionsWrite a 2–3 page paper in which you:Recommend at least three specific tasks that could be performed to improve the quality of data sets using the software development life cycle (SDLC) methodology. Include a thorough description of each activity per each phase.Recommend the actions that should be performed to optimize record selections and to improve database performance from a quantitative data quality assessment.Suggest three maintenance plans and three activities that could be performed to improve data quality.Suggest methods that would be efficient for planning proactive concurrency control methods and lock granularities. Assess how your selected method can be used to minimize the database security risks that may occur within a multiuser environment.Analyze how the method can be used to plan out the system effectively and ensure that the number of transactions does not produce record-level locking while the database is in operation.Go to the Strayer Library to find at least three quality resources in this assignment.