Web Application to Track Employee Training

  • Status Closed
  • 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.

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

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