USA: +1(669)289-8683 
Sign in
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.
Your Action Plan Report should address the following critical elements:
I. Executive Overview: Provide a general, high-level overview outlining the key issues, high-level recommendations, and important considerations to remediate performance and latency concerns. II. Performance Tuning a) Describe what types of tuning should be done to enhance database performance and how database transaction might be replicated to other database servers. b) Defend your recommendations using relevant research and explaining how you formed your conclusions. III. Query Design a) Explain the application of query design and how queries can be made more efficient, while attending to issues relating to joins, sub-queries, and sorting. Additionally, you should explain issues that could arise from select, update, and delete queries. Be sure to cater your explanation to the specifics of the scenario case. b) Consider how refining the selection criteria could enhance the efficiency of database queries. In other words, how would you propose attending to the issues relevant to queries highlighted in the scenario, and why? c) Design database queries for optimum performance for the scenario, and defend your conclusions. IV. Data Duplication and Redundancy a) Explain database normalization in terms of its use and purpose for the scenario. In other words, provide an explanation of database normalization and other techniques that can be utilized to reduce data duplication and redundancy within the scenario database. b) Defend the selection of techniques explained as being potential solutions for data duplication and redundancy within the scenario database. V. Multiple-User Access Issues and Errors a) Develop a strategy that will allow for troubleshooting run-time and application errors. Describe some common errors that are seen in commercial database systems and propose mitigation. b) Describe what high-level methods could be used to enhance multi-user access within databases in general. Create a set of database design specifications that would provide for multi-user access for the property tax payment and information system. The design specifications should provide details on concurrency control, record locking, and user security, and they should also provide room for future database growth. Discuss the impact of these changes and what resources would be required.
Milestones
Milestone One: Presentation for the Chief Information Officer (CIO) In Module Three, you will submit a Presentation for the Chief Information Officer (CIO). 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 in the Milestone One Rubric document for further information to guide you in creating your submission. This milestone will be graded using the Milestone One Rubric. Milestone Two: Action Plan Report In Module Six, you will submit an Action Plan Report. 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. Please review the Guidelines for Submission in the Milestone Two Rubric document for further information to guide you in creating your submission. This milestone will be graded using the Milestone Two Rubric.
Final Submission: Finalized Presentation to the CIO and Action Plan Report In Module Nine, you will submit a Finalized Presentation to the CIO and Action Plan Report. It should be a complete, polished artifact containing all of the critical elements of the final product. It should reflect the incorporation of feedback gained throughout the course. The Finalized Presentation will be graded using the Final Presentation Rubric. The Action Plan Report will be graded using the Final Action Plan Report Rubric.
Final Presentation Rubric Guidelines for Submission: This presentation should be approximately 5–6 slides, not including reference and title slides. All references should be in APA format. For more information on creating effective presentations, click here.
Critical Elements Exemplary (100%) Proficient (90%) Needs Improvement (70%) Not Evident (0%) Value Performance Tuning Meets “Proficient” criteria and provides high-level examples to enhance description of performance tuning types Describes types of tuning that would logically enhance database performance based on analysis of scenario information Describes types of tuning, but types would not logically enhance database performance or types are not based on analysis of scenario information Does not describe types of performance tuning 19 Query Design Meets “Proficient” criteria and explanation is supplemented with example queries to highlight best practices Explains the application of query designs and how queries can be made more efficient according to industry best practices Explains the application of query designs and how queries can be made more efficient, but not based on industry best practices Does not explain the application of query design and how queries can be made more efficient 19 Data Duplication and Redundancy Meets “Proficient” criteria and explanation is detailed with specific examples of techniques provided Explains data duplication and redundancy issues that could be occurring and provides logical normalization and other techniques for improving the scenario database Explains data duplication and redundancy issues that could be occurring and provides normalization and other techniques, but techniques would not logically improve the scenario database Does not explain data duplication and redundancy issues that could be occurring and provide normalization and other techniques 19 Multiple-User Access Issues and Errors: Concurrency Meets “Proficient” criteria and methods described are detailed and discussed with regard to the types of issues occurring Describes various applicable methods for solving record concurrency errors and issues as they occur in the scenario Describes various methods for solving record concurrency errors and issues, but methods may not be applicable to the issues as they occur in the scenario Does not describe various methods for solving record concurrency errors and issues 19 Multiple-User Access Issues and Errors: Enhancement Meets “Proficient” criteria and description of recommended methods is detailed to include specific improvements Describes and defends recommended methods that can be used to enhance multi-user access within the context of the scenario, and defense includes support Describes and defends recommended methods, but methods would not be useful in enhancing multi-user access within the context of the scenario or defense lacks clarity, detail, or support Does not describe and defend recommended methods for enhancing multi-user access 19 Articulation of Response Submission is free of errors related to citations, grammar, spelling, syntax, and organization and is presented in a professional and easy-to-read format Submission has no major errors related to citations, grammar, spelling, syntax, or organization Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas 5
Earned Total 100%
Final Action Plan Report Rubric Guidelines for Submission: Your report should be in APA format, following the organization, section inclusion, stylistic, and reference requirements for APA. For more information on creating successful APA reports, click here.
Critical Elements Exemplary (100%) Proficient (90%) Needs Improvement (70%) Not Evident (0%) Value Executive Overview Meets “Proficient” criteria and overview is detailed and precise so that it applies to both the scenario and issues common to the industry without unnecessary exclusion Provides an accurate, high-level overview outlining key issues, high-level recommendations, and important considerations to remediate performance and latency concerns Provides an overview, but overview is not high level, or does not accurately address key issues, high-level recommendations, and important considerations to remediate performances and latency concerns Does not provide an overview including high-level recommendations and important considerations to remediate performances and latency concerns 8.7 Performance Tuning: Types Meets “Proficient” criteria and clarity of recommendations is enhanced with specific examples and related cases Makes clear, logical recommendations for performance tuning for the scenario with a detailed explanation of how database transaction might be replicated to other servers Makes recommendations for performance tuning for the scenario with a detailed explanation of how database transaction might be replicated to other servers, but recommendations are not clear or are not logical Does not make recommendations for performance tuning for the scenario with a detailed explanation of how database transaction might be replicated to other servers 8.7 Performance Tuning: Defend Meets “Proficient” criteria and defense is qualified and supported using specific, relevant examples Provides a thorough, logical, and supported defense for performance tuning recommendations Provides a defense for performance tuning recommendations, but it is not thorough, not logical, or not supported Does not provide a defense for performance tuning recommendations 8.7 Query Design: Explanation Meets “Proficient” criteria and explanation is enhanced with clearly drawn connections between the scenario and best practice design techniques Provides a detailed explanation of query design and improvement techniques as related to the context of the scenario Provides an explanation of query design and improvement techniques, but it lacks detail or is not catered to the context of the scenario Does not provide an explanation of query design and improvement techniques 8.7 Query Design: Efficiency Meets “Proficient” criteria and recommendations are of a quality that would potentially enhance efficiency and could be implemented Makes thorough and reasonable recommendations for attending to query issues highlighted in the scenario Makes recommendations for attending to query issues highlighted in the scenario, but recommendations lack detail or reasonableness Does not make recommendations for attending to query issues highlighted in the scenario
8.7
Query Design: Design and Defend
Meets “Proficient” criteria and clearly evidences the use of best practices in design as applied to the scenario
Designs and defends database queries that would optimize performance in accordance with the scenario requirements
Designs and defends database queries for optimum performances, but the queries would not successfully optimize performance according to the requirements of the scenario
Does not design and defend database queries for optimum performances
8.7
Data Duplication and Redundancy: Explain
Meets “Proficient” criteria and the explanation of purpose of normalization and other techniques evidences recognition of best practices for the scenario
Accurately explains the use and purpose of database normalizations and other potentially useful techniques within the context of the scenario
Explains the use and purpose of database normalizations and other potentially useful techniques, but explanation lacks detail or accuracy, or is not explained within the context of the scenario
Does not explain the use and purpose of database normalizations and other potentially useful techniques
8.7
Data Duplication and Redundancy: Defend
Meets “Proficient” criteria and supporting rationale is qualified with relevant, real-world examples
Provides a logical defense and supporting rationale for normalization and other techniques for mitigating duplication and redundancy within the scenario
Provides a defense and supporting rationale for normalization and other techniques, but defense lacks detail or has gaps in logic
Does not provide a defense and supporting rationale for normalization and other techniques
8.7
Multiple-User Access Issues and Errors: Strategy
Meets “Proficient” criteria and quality of strategy is emphasized with supporting detail and cases evidencing best practices in developing multi-user strategy
Develops a multi-user strategy that will allow for troubleshooting run-time and application errors, specifically commonly occurring errors seen in commercial databases
Develops a multi-user strategy that will allow for troubleshooting, but strategy is not specific to those errors commonly seen in commercial databases
Does not develop a multi-user strategy that will allow for troubleshooting
8.7
Multiple-User Access Issues and Errors: Methods
Meets “Proficient” criteria and description evidences keen insight into the best practices in enhancing multi-user access
Accurately describes what highlevel methods could be used to enhance multi-user access within databases in general
Describes what high-level methods could be used to enhance multi-user access within databases in general, but with gaps in accuracy and detail
Does not describe which high-level methods could be used to enhance multi-user access within databases in general
8.7
Multiple-User Access Issues and Errors: Specifications
Meets “Proficient” criteria and database design requirements comprehensively address all aspects of the scenario accurately
Creates and discusses the impact of a set of database design requirements that would provide multi-user access for tax payment and information systems; provides details on controls, record locking, user security, and database growth
Creates and discusses the impact of a set of database design requirements, but does not attend to one of the specified topics, or discussion of impact lacks detail or accuracy
Does not create and discuss the impact of a set of database design requirements
8.7
Articulation of Response
Submission is free of errors related to citations, grammar, spelling, syntax, and organization and is presented in a professional and easy to read format
Submission has no major errors related to citations, grammar, spelling, syntax, or organization
Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas
Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas
4.3
Earned Total 100%
Jamie Vaughan
10 Dec 2017
Southern new Hampshire university
PERFORMANCE AND DATABASE EFICICIENY
QUERY DESIGN
The data retrieval will be improving speed with the performance tuning.
When looking a specific counties like Everstone county, there needs to be specific performance tuning, that will increase the direction the database will head towards, knowing the traffic numbers, this will make the client more efficient.
There will be random look-ups for the county of Everstone, that will increase the rate of access for the records that are in the database.
QUERY DESIGN
When looking at the response to check on a query for King county the provision will server the user the best results.
It is important to be able to know how to help when looking for performance queries by using the JOIN and WHERE clause when indexing.
If there are unused or unnecessary columns that are in the records, they need to be deleted, if not they will cause errors, there needs to be statements selected that will create loads for the database.
Outer join needs to be used less than inner join for the database.
QUERY DESIGN
When looking at the database, if there are errors coming up it is usally because there are inputting data information or there are redundancy issues.
To avoid redundancy on the database, normalization will be used to ensure integrity.
Redundancy will be avoided when using the proper use of foreign keys.
Everstone county will use a more centralized control of data, this will ensure no redundancy with data.
QUERY DESIGN
When creating records the locking technique needs to be used, this will help the DMBS from creating an update from another table or pull the wrong information into another process.
The database Everstone will have time stamping on all records, this will let everyone know who is doing what to the records and ensure that the data stays intact. This process will let the users to be able to cancel the process if need be.
QUERY DESIGN
Using multi-user environment will work best in the Everstone database.
The database will need to use the locking technique, the database will be maintained, another user can’t change the way the data is perceived but still allow multi-user access.
The database needs to setup as separate storage for the database for better functions for processing.
Splitting the database into different storage areas will better let Everstone ensure that multi-user can be employed effectively.
MULTIPLE USER ACCESS
The Everstone county database needs to work best in a multi-user environment.
Locking technique will ensure that a record being accessed by another process or user in the database is not retrieved by another process, this will help maintain database ,multi-user access.
Splitting the database will separate the data storage functions from the data processing functions.
Hence, splitting the database of Everstone county will go a long way in ensuring that a multi user environment is effectively supported.
References
Ong, S. K., Nee, A. Y. C., & Xu, Q. L. (2008). Design reuse in product development modeling, analysis and optimization. Hackensack, NJ: World Scientific.
Theobald, M. (2006). TopX: Efficient and versatile top-k query processing for text, structured, and semistructured data.
ActionPlan critical elements
CIO Presenation
I. Executive Overview: Provide a general, high-level overview outlining the key issues, high-level recommendations, and important considerations to remediate performance and latency concerns.
II. Performance Tuning a) Describe what types of tuning should be done to enhance database performance and how database transaction might be replicated to other database servers. b) Defend your recommendations using relevant research and explaining how you formed your conclusions.
III. Query Design
a) Explain the application of query design and how queries can be made more efficient, while attending to issues relating to joins, sub-queries, and sorting. Additionally, you should explain issues that could arise from select, update, and delete queries. Be sure to cater your explanation to the specifics of the scenario case.
b) Consider how refining the selection criteria could enhance the efficiency of database queries. In other words, how would you propose attending to the issues relevant to queries highlighted in the scenario, and why?
c) Design database queries for optimum performance for the scenario, and defend your conclusions.
IV. Data Duplication and Redundancy
a) Explain database normalization in terms of its use and
purpose for the scenario. In other words, provide an explanation of database normalization
and other techniques that can be utilized to reduce data duplication and redundancy within
the scenario database.
b) Defend the selection of techniques explained as being potential solutions for data
duplication and redundancy within the scenario database.
V. Multiple-User Access Issues and Errors
a) Develop a strategy that will allow for troubleshooting run-time and application errors.
Describe some common errors that are seen in commercial database systems and propose
mitigation.
b) Describe what high-level methods could be used to enhance multi-user access within
databases in general. Create a set of database design specifications that would provide for
multi-user access for the property tax payment and information system. The design
specifications should provide details on concurrency control, record locking, and user
security, and they should also provide room for future database growth. Discuss the impact
of these changes and what resources would be required.
