Assignment title: Management


Objective Create a UI interface with a single page that will display stats of how many ticket per status have been created per user. Requisite: - Create a solution using visual studio with MVC or Core preferable using C#. - Build and normalise a database preferably in SQL Server that connects to the UI interface. - Display the UI Interface using the following technologies: o HTML5 o Javascript (JQuery) only if needed. o Bootstrap 3 > or higher version o CSS Recommendations: - Use different layers to separate concerns. E.g:Data – Business Logic – UI. The expected Result. Part 1 – Approx 30 – 45 Minutes Included with these instructions is a Microsoft Excel spreadsheet. Create a Microsoft SQL database and normalise this data in the spreadsheet in to the new database. Part 2 – Approx. 30 – 45 Minutes Create a new Visual Studio solution using MVC Take the appropriate steps to allow your solution to read from the database created in part 1. Part 3 Approx. 30 – 45 Minutes Create a Web UI in HTML 5/ MVC to display the data from the database created in part 1.