Homework

Use the Word document just fill-in the information making it about 5-6 pages. Also the power point is the exactly the way it should look. 

IT professionals are often tasked with optimizing, tuning, and resolving various errors associated with large commercial database systems. As the world becomes more and more focused on the collection and use of data for various purposes, there is a greater need for building database applications that serve numerous complex functions. This final assessment will provide a comprehensive overview of the concepts, techniques, and skills that you have acquired throughout the course. The ability to interface a database management system with other applications and even third-party services is a commonly performed task in this discipline. The scenario, presented below, provides a real-world situation in which such skills will need to be employed.  
 
You will review the scenario and create a presentation that addresses, in detail, the key issues pertaining to performance and database efficiency, while touching on recommendations for improvements. You will then create a more detailed plan for addressing the problems highlighted in the scenario.  
 
Scenario The County of Everstone is a large county in a densely populated state in the United States. This county has a total of 34 incorporated cities within its boundaries. Overall, the county has a population exceeding 4 million residents. The county employs a proprietary database management system that is responsible for the county’s property tax assessment, parcel, and payment information. In a recent initiative, the county has been highly promoting the use of its online property tax payment and lookup information to reduce mailed payments and in-office visits. The marketing campaign for online property tax payments and information lookup has been highly successful. However, the county’s database systems have not sufficiently handled the increased traffic. As such, the web application available to residents often experiences high amounts of latency, frequently locks up, or in many instances is unavailable. 
 
The board of directors has asked executive IT management to look into the issue and provide a prompt resolution to the matter. A review of the hardware and software systems that the database management systems employ reveals that these systems “should” be able to take the capacity and load. Therefore, the IT management has ruled out the hardware systems as being the issue. Upon further investigation, a lead database systems administrator preliminarily reports that the issue appears to stem not from the hardware, but rather from a need to provide performance tuning on the database. The database design seems to be the culprit, since this database systems administrator noted large quantities of duplicated data, poorly written database queries, and triggers. 
 
Furthermore, the chief information officer (CIO) has also directed the web programmers and web developers to look at the web application for potential issues. The web development team has reported that while no design or programming issues were found with the web application, the stored procedures (queries) that it runs from the database server take long periods of time to run and frequently lock up the web servers. They suspect the queries were not designed for efficiency, as they were created before more individuals started using the online property tax payment system. 
 
The project is divided into two milestones, which will be submitted at various points throughout the course to scaffold learning and ensure quality final submissions. These milestones will be submitted in Modules Three and Six. The final product will be submitted in Module Nine. 
 

 
In this assignment, you will demonstrate your mastery of the following course outcomes:  
 
 Analyze database transactions to discover opportunities for performance tuning  Design database queries for optimum performance that adhere to given requirements and industry best practices  Resolve data duplication and redundancy issues using appropriate database normalization techniques  Respond to run-time errors and optimize database processing successfully by manipulating system parameters   Recommend specifications for advanced multi-user database applications that fit commercial database systems 
 
Prompts  
Prompt I: Presentation for the Chief Information Officer (CIO) To address the concerns of the board of directors, the CIO has asked you, as the manager of the database systems team, to provide a presentation that can be delivered to the board of directors. Your presentation should address in detail the key issues pertaining to performance and database efficiency, while touching on recommendations for improvements. The format and tool used for your presentation must be approved by your instructor. It is recommended, however, that free tools with IT support be used, such as Jing, or more traditional tools such as PowerPoint (with accompanying presentation notes), since they will allow you to record yourself giving a presentation. Please review the Guidelines for Submission above the Final Presentation Rubric in this document for further information to guide you in creating your submission. 
 
Specifically, the following critical elements must be addressed during your presentation: 
 
I. Performance Tuning: Describe what potential types of tuning could be done to enhance database performance, and how you determined this from your analysis of the provided information. II. Query Design: Explain the application of query design and how queries can be made more efficient, in general, according to industry best practices. Your discussion should specifically touch upon, at minimum, issues relating to joins, sub-queries, and sorting. III. Data Duplication and Redundancy: Provide an explanation of potential database normalization and other techniques that can be utilized to reduce data duplication and redundancy within the scenario organization. Describe areas where database redundancy could be occurring. Be sure to identify potential techniques that would improve the database within the context of the problem. IV. Multiple-User Access Issues and Errors: a) Describe various applicable methods that will resolve record concurrency errors and issues as they occur in the scenario. b) Describe methods that could be used to enhance multi-user access within the context of the commercial database used in the scenario. Be sure to defend your reasoning for recommending these methods. 
 
Prompt II: Action Plan Report The second portion of the final project will assume that you successfully presented to the board of directors, convincing them to move forward with your project to improve the functionality of the database. As such, you are asked to develop an action plan that builds upon your presentation and provides more detailed steps and narrative as to what specifically should be done to address the various performance and latency issues experienced by the County of Everstone. 

 
 
Your action plan will be in the form of an APA-style report, as is professionally acceptable. For further guidance in formatting and structure, please see the Guidelines for Submission located above the Final Action Plan Report Rubric.  
 

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 15% with the discount code SUCCESS