Web Application to Track Employee Training
- Status Closed
- Budget $30 - $250 USD
- Total Bids 19
This project is to develop create a web application using the Microsoft web stack ([url removed, login to view] MVC4, IIS, and SQL Server) based on the attached specifications.
PDQ Track Project
The goal of this project is to create a web application that will allow organizations to track the training and competencies of their employees.
This application is to be developed using [url removed, login to view] MVC 4 Release Candidate running on the Microsoft Stack (IIS, SQL Server, Windows Server).
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.
The spec calls for a RESTful URL structure that is built around the entities found in the database.
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 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 [url removed, login to view] 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 Training Units
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.Get free quotes for a project like this
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online