Web Application to Track Employee Training

This project is to develop create a web application using the Microsoft web stack (ASP.NET MVC4, IIS, and SQL Server) based on the attached specifications. PDQ Track Project Outline The goal of this project is to create a web application that will allow organizations to track the training and competencies of their employees. Technology Platform This application is to be developed using ASP.NET MVC 4 Release Candidate running on the Microsoft Stack (IIS, SQL Server, Windows Server). Supported Browsers Desktop Browsers: test against (and support) the latest versions of Chrome, Firefox, Safari, Opera, and IE8, IE9 and IE10. Database Structure Requirements The database should be developed so that the data consistency is guaranteed by the RDBMS itself (i.e. use foreign keys) with cascading deletes. Typically the cascading deletes are accomplished using INSTEAD OF triggers to avoid issues with circular references when using the cascading deletes feature built into SQL Server. URL Structure The spec calls for a RESTful URL structure that is built around the entities found in the database. Security This application will use forms authentication and will authenticate its users against the data contained in the “Login” table. Form a security viewpoint there are seven security states that must be considered when (or before) displaying a page: Anonymous users (can only login, create accounts) Authenticated Users who do not belong to the organization that owns the data being accessed Authenticated Users who do belong to the organization that owns the data being accessed Authenticated Users who do belong to the organization that owns the data being accessed and is a Training Assistant (role). Authenticated Users who do belong to the organization that owns the data being accessed and is a Training Coordinator (role). Authenticated Users who do belong to the organization that owns the data being accessed and is the supervisor of the worker whose data is being looked at/edited. Site Admin - Admin (bool) set to true in the login table. Notes about per-page security are found in square brackets on the Database and URLs document in the attached zip file. Typical Activities Typical Activities for “normal” Workers: Review their competency gaps. Gaps are the difference between the competencies they currently have and the competencies their current (or prospective) positions require. Register themselves for training. Review the competency gaps of workers who report to them (see the [login to view URL] field in the database model) and register them for training. Typical Activities for Training Assistants: All of the above plus ... Creating Training Unit Registrations for Workers Create Scheduled Courses Confirm Scheduled Course registrations Typical Activities for Training Coordinators: All of the above plus ... Create Positions Create Competencies Create Courses Create Training Units Create/Manage Groups Create/Manage Training Matrices Technical Specification Document I put together a technical specification document by modeling the data entities as they should look in a 3rd normal form database (see the Tables section), and then listing the URLs for the different pages that describe the different data entities (see the URLs section), and then listing the different forms and the data on each form (see the URLs & Data) section. This should provide a good foundation to help you determine the scope of this project. In addition, there is a PDF that includes wireframes of all the different URLs. Please read the project first and write the word "Understood". Also write your steps and suggestions to complete the project with a short description of what you understood.