c



When we talk about the present century, computers have become an important part of the day-
to-day life of the common people. Several electronic devices have been invented but it can be
said that computer has made the greatest impact on mankind than any other electronic devices.

Computers are used in fields such as educational institutions, office administration, factory
automation, medicine and sports. They find great applications in the fields for fine arts, politics,
military, government, engineering, Science and research, designing buildings and machines etc.

At present Computers and their applications significantly affect almost every aspect of Modern
Institutions, Government Offices and in Business. Therefore, designing and developing effective
database manipulating systems in business and in other firms, is becoming increasingly
important. One of such areas requiring the development of a fully-featured system is to develop
an intranet based online help desk for educational institutions which is accessible throughout the
campus.

Here is the project report on the development of ï
  
  web site. In the project
report you will come across the modules that are created in the project like


 ,  ,


  

 and 
  
.The
report consists of the  

  that depicts the functional model of our project
highlighting the functional relationship of the values computed by the system including input
values,output values and internal data stores.It also has an  that very well explains
our project with a detailed description about various entities involved in our project and the
description of each phase involved in development cycle ,thereby making it easy to understand.




 



Y

With full devotion and sincerety to GOD for his kind blessings,This is to extend our gratitude to
everyone who provided us a strong support for the successful development of our MCA 4th sem
project.

Firstly, my heartful thanks to my 

      !"#  for his continuous
guidance and constant support which helped us the most in developing this project.

My sincere thanks to $!!"!%! for being our source of encouragement throughout

the development of the project.

Lastly, very special thanks to all our fellow beings for their valuable ideas and criticisms that
helped us a lot in enriching our project further.

ALL ARE GREATLY ACKNOWLEDGED.


  
The aim of this project is to develop an intranet based online help desk for educational
institutions which is accessible throughout the campus to facilitate the various on-campus users
in providing information and requesting for the various services and facilities offered by a
particular institution including syllabus updates, results, attendance status, timetable updates,
exam schedules etc..

The proposed system will enable the users to make requests for the services available, by using
their login ID and PASSWORD provided by the administrator and these requests will be sent to
the concerned people to resolve them on time.

The system will also include report generators to generate periodic reports and email notification
feature to keep updating the users about the status of his/her request.

ï&'(!"!)!ï"*
Presently, the college does not provide any Online Help Desk facility to students, faculty and
other campus users to enquire about various college facilities or to register his/her complaints.
Thus the current manual management system often imposes several difficulties as follows:-

áY Lack of a responsive system for the students to inquire about about various facilities
provided in the college; events and other details.

áY Lack of an integrated system where all the required information, facilities, services
offered is put at one place.

áY Current system lacks time management and requires lot of human effort.

áY Currently, the students face the problem of communication gap in regards to the
information they require from the administrative cell. E.g. Information regarding a formal
procedure to apply for the various issues-like scholarships, documents retrieval, any
genre of authority approval.


ï&+,)!$ "#ï' ï()ïï  - )*
The online help desk is to be designed specifically to address the problems mentioned regarding
the current system. Keeping the problem of the current system in mind,

áY The proposed system is designed to build an intranet based integrated system to automate
the current manual system with the functionalities to provide online help and support to
various on-campus users thereby automating the manual system of logging the problems
via a web based system.

áY The major goal of the proposed system is to process the queries of various naïve users
and provide timely information thereby making it easy and feasible for the naïve users to
get a solution to their problems.

áY The proposed system will enable the users to request for the various available services
provided by the college.

áY The system will bridge the communication gap between students and administrative cell.

(). ï(ï"'!"' 

·Y An integrated system for easy access to the required information.

·Y Îuick and consistent response through email notifications.

·Y Time saving by providing an online platform in place of current manual system.

·Y Îuery processing.

·Y Login facility for different kinds of users.

·Y Maintaining up to date information.

·Y Feedback facility

·Y Îuery status check facility.

·Y Report generation facility.

(.",)!ï"',ïï"") ï()' *

Following is a list of functionalities of the system. More functionality that we find appropriate
can be added to this list.

There are registered people in the system (students, faculty, assignee and others).

There are four kinds of users for this system:

1.Y those who use the system to create a request (students)

2.Y those who look at the created requests and assign them to the concerned people (assignee)
3.Y those who work on the assigned requests and update the status of the same on the system
(faculty and staff members).
4.Y those who make necessary updates regarding various vital information.(faculty).

At the top, there is an µAdministrator¶ for doing the Admin-level functions such as creating user
accounts, adding new facilities to the system, adding new details etc. Administrator has the
privilege of updating, modifying and deleting any record from the database.

1.Y A person should be able to

áY login to the system through the first page of the application.
áY change the password after logging into the system.
áY view the status of the complaints registered by him/her (the status could be one of
registered/assigned/ in progress/pending/completed/rejected).
áY view the list of requests (both open and closed) created by him/her over the past.
áY register a new complaint by specifying the complaint type, the severity of the
request (there may be several levels of severity defined) and a brief description of
the request.
áY close a request created by him/her by giving an appropriate reason.
áY see the requests that are assigned to him/her by the facility-heads and update the
status of requests (after working on them).
áY view the incoming requests (if he/she is a facility-head) and assign them to
registered users of the system.
áY get help about the OHD system on how to use the different features of the system.

2. As soon as a request is created, an automatic email should be sent to the person who created
the request and the concerned facility-head. The mail should contain the request details.

3. Similarly, when any status-change occurs for a request (such as the request getting completed
etc), an automatic email should be sent to the person who created the request and the concerned
facility-head.



 
c




Y
¢



 


 
 

 

   

1 PC with 2 GB hard-disk and Not-Applicable

256 MB RAM




 


 
 

 

1 Operating System Windows 95/98/XP/vista/07

2 Front End ASP.NET

3 Language used C sharp(C #)

4 Back End MS-SQL server 2005

  



 


The application has a front end that acts as an interface to the users of the application. The front
end is to be developed using ")(
 (ASP.NET) which possess following features:

áY .Net Framework is a platform or development environment to seamlessly create web-

applications that are accessible through client machines from across the globe.

áY .Net Framework is platform independent and language independent

áY .Net Framework enables you to use various off-the-shelf libraries that help the
development of applications faster, easier, and cheaper

áY .Net Framework supports so many programming languages because of the concept of

Common Language Runtime (CLR) engine. The CLR engine, instead of compiling the
code into native code, compiles the code into Microsoft Intermediate Language (MSIL).
The MSIL, a set of instructions, then translates the code into native code.

áY The .Net Framework provides a number of advantages such as fewer lines of code,
complete compilation, ease of deployment, web settings and web.config, and caching

áY .Net Framework includes Web controls, Web forms, and server-side blocks of code are
compiled when a page is requested for compilation.



Language that we used for coding web pages is , / which is a multi-paradigm
programming language encompassing imperative, functional, generic, object-oriented (class-
based), and component-oriented programming disciplines.

áY C# is one of the programming languages designed for the Common Language

Infrastructure.
áY C# language is intended to be a simple, modern, general-purpose, object-oriented
programming language.
áY The language, and implementations thereof, should provide support for software
engineering principles such as strong type checking, array bounds checking, detection of
 attempts to use uninitialized variables, and automatic garbage collection. Software
robustness, durability, and programmer productivity are important.
áY C# is intended to be suitable for writing applications for both hosted and embedded
systems, ranging from the very large that use sophisticated operating systems, down to
the very small having dedicated functions.




The RDBMS used for designing the database for the project is 0' $1223

SÎL Server 2005 includes SÎL Server Management Studio, a new integrated suite of
management tools with the functionality to develop, deploy, and troubleshoot SÎL Server
databases, as well as enhancements to previous functionality.

SÎL Server supports different data types, including primary types such as =
, 
,

,  (including character strings), 
 (variable length character strings), binary
(for unstructured blobs of data), 
(for textual data) among others.

With SÎL Server 2005 developers can create database objects using familiar languages such as
Microsoft Visual C# .NET and Microsoft Visual Basic .NET. Developers can also create two
new objects²user-defined types and aggregates.

The security model in SÎL Server 2005 separate users from objects, provides fine-grain access,
and enables greater control of data access.

Additionally, all system tables are implemented as views, providing more control over database
system objects.

Report Builder is a component of SÎL Server 2005 Reporting Services that enables business
users to create and deploy reports with a user-friendly enterprise data model.
 



c






 4

  ' ,
 (SDLC) is a conceptual model used in project
management that describes the stages involved in an information system development project,
from an initial feasibility study through maintenance of the completed application System
Development Life Cycl (SDLC) means the cycle through which the candidate system goes
during it's development phase To understand the system development, we need to recognize that
a candidate system has a life cycle, just like a living system or a new product. System analysis
and design are keyed to the system life cycle. The analyst must progress from one stage to the
other methodically, answering the key questions and achieving results in each stage. Until
software system is implemented and delivered to a customer and even after that the system
undergoes gradual development and evolution i.e. it is said to have a life cycle composed of
several stages and that life cycle is called system development life cycle and it consists of a set of
activities that the analysts, designers and users carry to develop an system.

Below is the detailed description of each stage of SDLC that is carried out in this project.


 




The main purpose of conducting system analysis is to study the various processes and to find out
its requirements.

System analysis has been conducted with the following objectives in mind:

1)Y Identify the user¶ need mainly the students¶ requirement.

2)Y Evaluate the system concept for feasibility.
3)Y Allocate functions to software, people, database, and other system elements.
4)Y Establish schedule constraints.
5)Y Create a system definition that forms the foundation for further stages of development.
System Analysis includes requirement analysis. All the necessary details required in the
analysis of our project are collected from the students, faculty and the staff members who are
going to use the software. The features that should be present in the software as felt from a
student¶s point of view are analysed .The requirement analysis played an important role in
identifying what the college wants from the proposed system. All the analysis was done in
accordance to the user¶s requirements so that the proper designing could be done and the
requirements can be fulfilled.
This is the phase during which the problem is identified, alternate system solutions are studied,
and recommendations are made about the proposed system.

5  
By studying the prevalent system in the department, the requirement for the Online Help Desk to
be implemented in the college has become crystal clear. The main requirement is to create a
database that should be manageable. Next important requirement is the generation of relevant
information from the database or specialized reports for the management. Another constraint was
that there is need of a platform through which Students can easily register their complaints
regarding different issues of the college and get updated periodically . Separate and independent
modules for maintaining student details, faculty details, staff details ,course details, etc. is to be
created. Feedback module is equally required to collect users¶ responses and comments
regarding the performance of this website.
 After understanding the problem definition and the requirement analysis in detail, preliminary
investigation was carried out for which different sources of information including students,
faculty, staff members and other on campus users were interviewed.

'!!"-!"$ )!#)!ï"

  *

a)Y What is their views regarding the current manual system of complaint handling and query
processing?
b)Y What sort of problems do they face in activities related with administration cell ?
c)Y What sort of problems do they face in their departments regarding their academic cell.?
d)Y What types of information updates are needed?
e)Y What are their expectations from the online help desk websites?
f)Y What reports they desire on informational basis?
g)Y What are the outputs expected from the software?

(
*

a)Y What type of difficulty they face in handling student¶s queries related to their academic reports?
b)Y What type of student¶s queries they normally handle?
c)Y What information is required to be maintained?
d)Y What are the expectations from the software?
e)Y What are the outputs required from the software?
f)Y What reports they desire for internal monitoring of daily activities?


( !&!'!)- ).-

Once the system objectives have been ascertained by initial investigation, the feasibility study is
conducted to check whether the system is feasible regarding following aspects.

)/ 
6
*

The technologies or the tools required for the project development are readily available and can be easily
integrated within the department.

)6
*

Determines that the project can be implemented fully within a stipulated time frame or not.


6
*

Determines that the project will be fully acceptable by the users i.e. the students ,the faculty and
the staff members of the department.


 


 




 ‰ser id password
‰ser Type

Sec _ques u

 Email id
Year
Answer 1 name
Created
for
'  

N

payscale
got

ID
Dob email
1
name

email Branch Sex

email name
designation
1
dept reg_no
Year_of_ad

    contac t



subject name
1 1
Course
Rollno
ID address
address
address contact

from M
Sr_no post
contac t 1
N
Assign_date

 % Registers

Complain_id
comments date N
Assigned
   

to
Course id Sub _code N
type status
Sub_name
& 1 desc
M
ta
secured
Max_marks
Date_of_cmpl
in Max_class

 Mark_obt 1



 Prac_marks

Class_attend 1
has 1
1

!"#$ 
 
   

Retrieves Information Provides Information

Maintains ‰ser
Logins Online Help Account
‰ser Administrator
Desk
Generates Reports
‰ploads Information

Generates Reports

( !)u!*!uu(+#$



 u!*!u,u(+#$
Student
Enter ‰ser Id, password

Complaint
Details

‰pdate Assigned Register

Complaint by Complaint
Staff
Status

Assignee
Assigned to

Marks Details

Marksheet Report
Faculty ‰pload Generation
Marks Marks

Enter
‰serID, Attendance
Attendance
Password ‰pload

Login

Attendance Details
Enter
‰serID,
Password ‰ser Information ‰ser Account
Entry ‰ser Account Information
Administrator Management

 ‰ploads
Details
Details

u!*!u-u(+#$

‰ser account
‰serID,Password information

Faculty
‰serID,Password
Login information
1.1
Administrator
Login
‰serID,Password

Student

u!*!u-u(+#$(u(# 

Subject details

Student details
1.2
details
‰pload Faculty details
Administrator Details

Staff details

u!*!u-u(+#$(.'u(!u




 Marks details Attendance

marks Student

Student details Marks
Student details Faculty
 1.3 Student Report
Attendance
Attendance details Administrator
Report
Generation
Faculty details
Faculty Details
Faculty Report
Staff details
Staff Details Staff Report

u!*!u-u(+#$(!'(#! !( 


Student

Marks Marks Details

Marks Retrieves Marks Information

Faculty
Information Display Marks 
Information


Validate marks
Marks Information

Student Information Subject Information
Student Performance
Report

Student Details Subject Details

u!*!u-u(+#$( ($( 
.'!/!!*u
  !#"ï'

In this software project, the 
 


is used for development. Because spiral model,
combines the iterative nature of prototyping with the controlled and systematic aspects of the
waterfall model, there in providing the potential for rapid development of incremental versions
of the software. In this model the software is developed in a series of incremental releases with
the early stages being either paper models or prototypes. Later iterations become increasingly
more complete versions of the product So, overall this project has been developed in iterative
manner ,following all the stages of the development .but still it possess certain areas of
enhancements that can be done after once implemented for use so as to release its more advanced
version by incorporating the changes demanded by user.

The model is divided into a number of task regions. These regions are:

1.Y The customer communication task ± to establish effective communication between developer
and customer.
2.Y The planning task ± to define resources, time lines and other project related information.
3.Y The risk analysis task ± to assess both technical and management risks.
4.Y The engineering task ± to build one or more representations of the application.
5.Y The construction and release task ± to construct, test, install and provide user support (e.g.,
documentation and training).
6.Y The customer evaluation task ± to obtain customer feedback based on the evaluation of the
software representation created during the engineering stage and implemented during the install
stage.
  



 Admin

 Login

 Student

 Faculty

Staff
Online Help Desk

Attendance

Marks

Complaints

Course



 
 c 



 *

Admin module is mainly concerned with the database activities like populating the database,
updation of and maintenance of database. As well as this module will be also responsible for the
creation and maintenance of user accounts and keeping track of various probable security issues.

'
 *

Login module will take care of the user (student, faculty, staff , assignee) or the administrator
login into the system and allow them to use the system as per their access permission. It will
check the authorization of user and allow them to access the system.

  *

Student module maintains the records of all the students in the college.

(
*

Faculty module maintains the details of all the faculties of various department of the college.

*

Staff module maintains the details of all the staff members of various departments of the college
e.g.: administrative cell, account section, transports section etc.

  *

Attendance module maintains and displays the attendance details of students and generates
attendance report.

 
*

Faculty is authorized to update the sessional marks obtained by the students in their subject and
also enables the students to generate their performance report.


,

 *

The complaint module provides the complaint details registered by the students, the details of
faculty and staff to whom the complaint is assigned to, by the assignee, status of the complaint
that is updated by faculty or staff who works on that complaint and also generates complaint
reports based on different criteria provided by users.

,
*

Course module list the details of the different courses offered by the college and list of subject
details for each course.


 





 





u



0 

 0 


 0 

&0 














,

 7





/






6 





 





 c













 





6
 




'
 






 




(







  




ï/






 




(6 





 

c 



Help Desk reports play a vital role as far as Help Desk product is concerned.
Reports that can be generated by this OHD Systems are listed below:

áY Reports of all requests.

áY Reports of completed requests.

áY Reports of pending requests.

áY Periodic reports to track the number of complaints logged within a specific time frame.

áY Customized reports that will filter out complaints based on various departments and
facilities, as well as according to the request date.

áY Students¶ attendance reports.

áY Performance reports.

áY Subject wise evaluation reports.

áY Misc. reports based on Students¶ details, Faculty details, etc.


  7






 7






(
7



  7






,

 7





,

 7