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.