You are part of a team providing level 2 and level 3 support to a school management system. The system consists of an Azure SQL database, A Web Api and a Web Portal to look up a Student Record.
Below is a simple architecture diagram of the system.
---
Title: Architecture Diagram
---
graph LR;
StudentPortal[Student Portal];
WebApi[Web Api];
Database[(Database)];
AppInsights([Application Insights])
StudentPortal-->WebApi;
WebApi-->Database;
Database-->WebApi;
WebApi-->StudentPortal;
StudentPortal-->AppInsights
WebApi-->AppInsights
Below is a Entity Relationship diagram for the database
erDiagram
STUDENT }|--|| ENROLLMENT : Enrolls
STUDENT {
int Id PK
string FirstMidName
string LastName
DateTime EnrollmentDate
}
ENROLLMENT ||--|{ COURSE : EnrolledOn
ENROLLMENT {
int EnrollmentId PK
int CourseId FK
int StudentId FK
int Grade
}
COURSE ||--|{ DEPARTMENT : InDepartment
COURSE }|--|| COURSEASSIGNMENT : Assignment
COURSE {
int CourseId PK
string Title
int Credits
int DepartmentId FK
}
DEPARTMENT ||--o| INSTRUCTOR : ManagedBy
DEPARTMENT {
int DepartmentId PK
string Name
decimal Budget
DateTime StartDate
int InstructorId FK
}
COURSEASSIGNMENT ||--|{ INSTRUCTOR : Teaches
COURSEASSIGNMENT {
int InstructorId PK, FK
int CourseId PK, FK
}
INSTRUCTOR |o--|| OFFICEASSIGNMENT : Located
INSTRUCTOR {
int Id PK
string FirstMidName
string LastName
DateTime HireDate
}
OFFICEASSIGNMENT {
int InstructorId PK, FK
string Location
}
An incident has been raised informing you that the Web Api appears to be unavailable. You've been tasked with diagnosing and fixing the issue. Can you diagnose the failure in the system? Once identified can you provide an appropiate fix and if required deploy it? Can you test your fix has resolved the issue?
A production bug has been raised for the StudentPortal and assigned to your team. You've been tasked with diagnosing and fixing the code. Can you diagnose the error in the code? Once identified can you provide an appropiate fix and deploy it? Can you verify the code now works as expected? Are there ways for you to identify these issues ahead of time?
On the Student Data page the total number of credits for the student is showing an incorrect value
- Access the Student Portal site
- Enter the follow details in the form FirstName: Carson LastName: Alexander
- Submit the form
- On the Data page the total number of credits is showing as 3, when the total should be 9.
Your team are responsible for managing the Bulk upload of the new Students each year. This process is typically done with a CSV file and Powershell script. You've attempted to run the script to do the data upload but the script has failed. Can you diagnose why the script is failing? Can you fix the script and demonstrate it working?