Context:

“ASP Training Institute” is a small company that specializes in IT related training. The company offers workshops for both individuals and organizations. Workshops can be offered in the company’s facilities and are open to both individuals and group registrations. “ASP Training Institute” also offers workshops for various organizations in their facilities. These sessions are to be attended by the organization’s employees only. The company has several full and part time staff with different areas of IT expertise.

As the business has grown, the ASP Training Institute company needs a computer system to handle information about workshops and registrations. Currently, registrations are made by phone and data is stored in an Excel spreadsheet. The company wants the new system to keep information about trainers and workshops as well as allow individuals and organizations to register for the workshops.

General Requirements

There will be three levels of users: administrator, trainer and registrants.

The Administrator will

  1. edit his own credentials
  2. create and edit trainer accounts
  3. indicate which workshops will be offered each month
  4. specify which trainer is assigned to which workshop, based on their expertise
  5. generate a report for a specific workshop
  6. lookup the status of a particular registrant
  7. generate a report about the schedule of a particular trainer

The Trainer will

  1. edit his/her credentials, contact info
  2. update his/her areas of expertise
  3. generate a list of registrants for a specific workshop
  4. update his/her availability

The Registrant will

  1. be able to register in the system
  2. edit his/her credentials, contact info
  3. be able to register for a workshop
  4. be able to arrange a workshop in the case of an organization wanting to train their employees in their facilities.

Technology/tool to be used

The system will be a web based application that will be developed using ASP.NET and SQL server databases. I plan to use Visual Studio 2012, the code will be written in C# and I will use the SQL Server Express that comes with Visual Studio.