A basic summary solution about this project. If Possible. No need to create anything, just explanation about which software and how to do it. ???

company operatesin the UK and US. Due to its success, is expanding throughout the world by taking advantage of cloud architecture. A distributeddatabase design is necessarythat meets the needs of a new cloud-based applicationthat is globally accessible. Your goal will be to design the IT architecture that supports the distributed database(s). This includes an example server(s) (e.g. you can use a VM(s)) with proper optimizations and the supporting services(s) installed. Additionally, you will design and implement the physical databaseon this system(s). Once populated, you will write supporting data reports via SQL and optimize these using explain plans. Finally, your group will give professional presentations on the solutions to the customer/audience and respond to feedback for improvement.currently employs 10,000 personnelsplit between the UK/USwho serve as accountants, human resource experts, systems analysts, developers, managers, testers, maintenance engineers, lawyers, and sales representatives.Records for each individual are essential, from an associated supervisor to departmental roles.has more than780clients in the US and UK. Clients are recognizedby various names. Sales refers to clients by typical names while legal uses legal names.An example is Button Hardware Token. s legal team references itsfull legal name Button Hardware Token, Inc. but the sales, marketing, and consultants denoteit as BT. Bothcommon/legalnames must be available to all DBMS stakeholders. All client contact and relevant business information must be stored and recorded in the DBMS.Clients have contactsthat employees must record and access for business. s sales representatives must know a clients billing, sales, and contactinformation.Clients can have one or more contracts with to provide a variety of consulting amenities. Some clientshavepre-negotiated contractsfor which that are billed, these are often referred to asfixed price. Alternatively, hourly contracts exist that require labor rates/hours to calculate billing details. managers must guaranteethat when maximum (cap) contact hours are past what the client agreed to, that the clients are not billed for suchadditional hours.Rate per hour must be researched in the major UK and US cities as estimations for different levels of managers, contractors, accountants, lawyers, HR, and software developers for example.employees must use time cards for all hours worked. These must associate with specific companies along with the consulting projects your company is currently responsible for completing. Personnelcan be assigned to many dissimilarprojects.They can also be re-assigned. A general problem with this is maximum hours worked in a week. Certain countries have maximum hours per week that an employee can work and therefore this needs to be recorded and monitored by supervisors.Contractscan consist of multipleprojects. If a contract specifies a maximum number of hours for service implementation, the project managers of each project shouldagree how to split up the max cap amounts between the two projects and maintain appropriate reporting on hours. Hours are important in the database, including contract, project, and personnel hours.Billing and invoice management systems will also need these hours.The number of hours worked for the workforce is a daily task. An example time card looks likethis:Project Deliverables:Refer to the project grading rubric for assessment details.An APA formatted paper that includes all project deliverablesoOneAPA formatted paper is necessary that includes the diagrams, screenshots, and configurations of thefinal solution.oInclude an introduction, review of related literature that informs the infrastructure and database design (e.g. include best practices, design frameworks, and standards), and develop a strong conclusionto the project.oPlace all relevant artifacts including the design diagrams in appendices.oInclude supporting OS/database configurations in the appendices of the report.oInclude all query results, stored procedures, explain plans, and SQL adjustment differences per the optimizationplansin the appendices of the report.oInclude the presentation/slides in an appendix.oHave the project manager submit the final Word document to D2L.Design the IT infrastructure that supports the distributed database oUse a proper modeling software such as Microsoft Visio.oInclude the proper routing, switching, server, security, load balancing, and virtualization architecture necessary to support a global DBMS.oUtilizesupporting architectural frameworks and best practices. Design an optimalEntity RelationshipDiagram(ERD)fors global DBMSoUse proper database modeling software.oUsecrows foot notation, include all details such as attributes, attribute types,relationships, relationship descriptions, and constraints.oNormalize the database in 3NF or higher. Optimize and implement the designed prototype database server(s)oDescribe all optimizations made, from the hardware to the software to support a global DBMS.oFor example, were kernel, disk, or memory allocation customizations made?Optimize and install the designed database(s)on the configured server(s)(use VMs)oDescribe what steps were taken to tune the database(s) to the customer requirements.Populate the tables with at least 20 records eachDevelop and adjust the following SQL reports for optimal performanceoCreate a SQL report that allows management to track all benefits, such as holidays, and whether users have depleted these benefits (e.g. taken all their vacation days).oCreate a SQL report that tracks overtime hours of all employees by country and identifies if/when overtime occurs given the associated governments maximum allowable hours per week (research labor laws to complete).oCreate a SQL report that tracks all contract hours by contract and project for billing.oAdditionally, each team membermust generate one individual stored procedure that helps maintain or optimize the DBMS and present their stored procedure during the presentation. It must minimally contain three valuable functions and touch three (3) or moretables during implementation that help the customers.Progress Project PresentationoRefer to the presentation rubric for assessment details.oAn initial and a final presentation will be given, where the initial presentation will show the teams progress prior to the final solution. This will allow an opportunity for feedback andimprovement prior to the final project presentation.oThe initial or progress presentation will present the IT infrastructure and architectural design diagrams, thefinal cut entity relationship diagrams, and demonstrate the initial server(s) optimizations in preparation for the DBMS deployment and implementation