Question 2: Database Design and Management Requirements: You are to review the database design and management practices in place at GoNCharge. You are to:
Evaluate the current database schema for efficiency, scalability, and security.
Identify any potential data integrity issues that may arise from the current schema.
Recommend at least two improvements to GoNCharge’s approach to database design and management.
From the case description, identify potential issues with GoNCharge’s current database design and management practices. This should be a section within your Business Consulting Report. These recommendations do not need to address all possible issues, but certainly should address the most pressing, prominent concerns around database design and management. Your assessment and recommendations should consider the context for GoNCharge, and the information provided in this specification, as well as any further information you obtain during the engagement.
Supporting SQL Scripts:
- Script 1: SQL script used to evaluate the current database schema for efficiency.
- Script 2: SQL script used to identify potential data integrity issues in the current schema.
- Script 3: SQL script used to recommend an improvement to GoNCharge’s approach to database design.
- Script 4: SQL script used to recommend an improvement to GoNCharge’s approach to database management.
Question 3: IT Service Management Assessment and Recommendations Requirements: You are to review the IT service management practices in place at GoNCharge. You are to:
Evaluate whether IT service delivery aligns with business objectives.
Assess whether IT service delivery is effective or ineffective based on industry best practices such as ITIL v4.
Recommend at least two improvements for GoNCharge’s approach to IT service management.
From the case description, identify potential issues with GoNCharge’s current IT service management practices. This should be a section within your Business Consulting Report. These recommendations do not need to address all possible issues, but certainly should address the most pressing, prominent concerns around IT service management. Your assessment and recommendations should consider the context for GoNCharge, and the information provided in this specification, as well as any further information you obtain during the engagement.
Supporting SQL Scripts:
- Script 1: SQL script used to evaluate whether IT service delivery aligns with business objectives.
- Script 2: SQL script used to assess whether IT service delivery is effective based on industry best practices.
- Script 3: SQL script used to recommend an improvement to GoNCharge’s approach to IT service management.
- Script 4: SQL script used to recommend another improvement to GoNCharge’s approach to IT service management.
Question 4: Data Analytics Assessment and Recommendations Requirements: You are to review the data analytics practices in place at GoNCharge. You are to:
Evaluate how well GoNCharge is leveraging its data assets.
Identify areas where data analytics can provide value to GoNCharge.
Recommend at least two improvements for GoNCharge’s approach to data analytics.
From the case description, identify potential issues with GoNCharge’s current data analytics practices. This should be a section within your Business Consulting Report. These recommendations do not need to address all possible issues, but certainly should address the most pressing, prominent concerns around data analytics. Your assessment and recommendations should consider the context for GoNCharge, and the information provided in this specification, as well as any further information you obtain during the engagement.
Supporting SQL Scripts:
- Script 1: SQL script used to evaluate how well GoNCharge is leveraging its data assets.
- Script 2: SQL script used to identify areas where data analytics can provide value to GoNCharge.
- Script 3: SQL script used to recommend an improvement to GoNCharge’s approach to data analytics.
- Script 4: SQL script used to recommend another improvement to GoNCharge’s approach to data analytics.