Closed

Web Application to Track Employee Training

This project received 19 bids from talented freelancers with an average bid price of $749 USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $250 USD
Total Bids
19
Project Description

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

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 [url removed, login to view] 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 [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 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.

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online