Imagine you work in the IT department of a new company called Web Assets (WA), located in Denver CO. WA builds custom Websites and provides technical support for clients. The Chief Information Officer (CIO) wants you to create a new customer database using Microsoft SQL 2012 that will interface with the company’s Web server, so that any inquiries or potential customer data can be stored and retrieved by the sales force. The company is expecting to expand and offer these same services in Phoenix AZ, and Sacramento CA. The pertinent information required from each potential customer includes: Since there will be three (3) sites, the CIO wants to ensure that the database and Website are available for customers 24 / 7 days a week. , please view the “Submit a Clickable Rubric Assignment” video in the Student Center. , training on how to grade is within the Instructor Center.” Write a six to eight (6-8) page paper in which you: Your assignment must follow these formatting requirements: The specific course learning outcomes associated with this assignment are: Purchase the answer to view it

Creating a Highly Available Customer Database for Web Assets

In today’s competitive business environment, companies rely heavily on their IT infrastructure to support their operations and meet customer demands. For a company like Web Assets (WA) that builds custom websites and provides technical support, having a highly available customer database is crucial. The Chief Information Officer (CIO) of WA has tasked the IT department with creating a new customer database using Microsoft SQL 2012. The database needs to interface with the company’s web server to store and retrieve customer inquiries and data for the sales force. Moreover, as the company plans to expand its services to Phoenix, AZ and Sacramento, CA, the CIO wants to ensure that the database and website are available for customers 24/7.

Availability Requirements:
To achieve high availability, the customer database and web server need to be accessible at all times, without any downtime. This means the infrastructure needs to be designed and implemented in a way that ensures fault tolerance, scalability, and reliability. One approach to achieve this is by implementing database mirroring, which creates an exact copy of the database on a separate server. This ensures that if one server goes down, the other server can take over, minimizing downtime. Additionally, a load balancer can be used to distribute incoming web traffic across multiple web servers, increasing performance and redundancy.

Database Design:
When designing the customer database, several factors need to be considered to ensure efficient data storage and retrieval. The database schema should include all the necessary tables and relationships to capture the pertinent information required from each potential customer. This may include fields such as customer name, contact information, project details, and any specific requirements.

To handle the potential data growth, the database design should also incorporate scalability. This can be achieved by implementing partitioning, which divides the data across multiple physical storage devices or servers. This allows the database to handle increased data volumes without sacrificing performance. Furthermore, the database should be optimized for fast data retrieval by creating indexes on frequently used columns and using query optimization techniques.

Web Server Infrastructure:
The web server infrastructure needs to be designed to handle the anticipated web traffic and provide high availability. This can be achieved by using a load balancer to distribute incoming requests across multiple web servers. Additionally, web servers should be provisioned with redundant hardware components, such as redundant power supplies and network interfaces, to minimize the impact of hardware failures.

To ensure high availability, the web server infrastructure should be geographically distributed across multiple locations. This can be accomplished by deploying web servers in each of the company’s planned locations – Denver, CO; Phoenix, AZ; and Sacramento, CA. Each location should have redundant internet connections and power sources to minimize the risk of service disruption.

Creating a highly available customer database and web server infrastructure is essential for a company like Web Assets (WA) to provide uninterrupted services to its customers. By implementing fault-tolerant database mirroring, partitioning, and load balancing, WA can ensure that its customer data is safe and accessible at all times. Furthermore, deploying geographically distributed web servers with redundant hardware components will ensure that the website remains available 24/7, even in the event of a localized failure. Building a highly available IT infrastructure requires careful planning, design, and implementation, but the benefits of increased reliability and customer satisfaction far outweigh the investment.

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.

Click Here to Make an Order Click Here to Hire a Writer