Counseling System

COUNSELING SYSTEM PROJECT REPORT | COUNSELING SYSTEM

Project Overview

This project entitled "COUNSELING SYSTEM" is basically a prototype of a Counseling system. It provides the facility to students.

INTRODUCTION

 

The Counseling System is developed to enhance counseling. This software provides great relief to the students; fully works as an online. This software includes as it the facility of Reporting, Registration and searching the information about college and university and gives an overview of the entire institute in a short interval time and will also help to the University and college to manage in the whole counseling procedure.

Online Education helps the students for appearing the exam by online. Its mission is to offer a quick and easy way to appear the exam and it also provides the result immediately after the exam. Through partnerships with agencies\boards which are conducting the multiple-choice type Education, it can provide special advantages to the applicants/students that can't be found anywhere else.

 

The working of the project is as follows.

 

The first the page provides several links. The Home link contains several pieces of information about online education; it provides a link to the login page.

 

In the Login link a user have to login before entering for the exam. An already registered user can simply type in his\her valid username and password, and then click the "Login" button. Already registered users can only register a new user as a teacher. But those visitors who are not registered have to go to the registration page for registering only as a student before they log in. In that page user have to enter Name, Address, Phone number, Role id, and password; and also the user has to update the photo.

 

 

 

 

 

          BACKGROUND

 

 Existing system of “Counseling Management System” works manually or computerized in a building. Therefore all types works are maintain in building. So maintain all the counseling procedure very difficult.

 

If we are reporting, then we need go to the University and get a form for reporting and fill the form and submit in the queue conditions. Then verify their form by the university and maintain the record in computer or register. The system is mainly related to counseling management system. Which is developing a web based application system, it is necessary to make a thorough study of the existing system. There is no Counseling System. The all the information not maintains globally. Therefore to maintain all the information of university is very difficult.

 

 

 

          OBJECTIVE

 

Counseling Management System is fully work as online using the centralized database, which  provides online facilitysuch as- Student Counseling , Managing the student record, Managing the Institute record and Searching the any other information about Counseling procedure/Institutes, this types of information easy to search through the software. The package will require data to be entered in user-friendly manner.

 

The proposed system will aim to automate all the activities and eliminate all the drawbacks that the existing system of manual operation faces. The important features of functionality of the proposed system are listed below-

 

1.      The proposed system will save a significant amount of time and effort invested by the university every year.

2.      It fully works as an online and centralized database to maintain all information.

3.      It helps the university to dynamically add records to the database.

4.      Easy to Searching the information about college or university.

5.      Easy to managing whole counseling procedure

 

 

 

          Purpose and Scope

 

Purpose

 

In proposed system at first reduce the problem, which is faced in Existing System. So the proposed system, “Counseling System” will provide the centralized database facility for reporting/registration or access any type of information about the college/university and globally maintain all the information by the university and college.

 

Scope

 

This types of information Online, and Efficient and systematic maintenance of the huge Database, speeding up queries and faster processing are the factor for going for this project.This system is applicable for any university /Institute.The package will require data to be entered in user-friendly forms. This system provide the scope of online working using the centralized database such as Student reporting,counseling,Institute registration for counseling, searching the information of counseling procedure and total seats of college etc.

 

 

Survey of Technology

 

As per the requirement of tools & platform for my project “Counseling System”, I have decided the following platform & tools.

 

Front End: -       

ASP.Net 3.5 (With C#)

 

            ASP.NET is a web application framework developed and marketed by Microsoft to allow programmers to build dynamic web sites, web applications and web services. It provides a unified Web development model that includes the services necessary for developers to build enterprise-class Web applications. ASP.NET offers a novel programming model and infrastructure that facilitates a powerful new class of applications. It provides easy-to-use application and session-state-facilities that are readily compatible with all other .NET framework APIs. It is a compiled .NET-based environment, so one can author applications in any .NET compatible language and is known for Common Language Runtime environment, type safety, inheritance, and so on. Some of the features of ASP.NET include:

 

1.      Flexible Language Options:ASP.NET now supports more than 25 .NET languages giving flexibility in the choice of language.

2.      Rich Class Framework:The .NET Framework offers over 4500 classes that encapsulate rich functionality like XML, data access, file upload, regular expressions, image generation, performance monitoring and logging.

3.      Compiled execution:ASP.NET will automatically detect any changes, dynamically compile the files if needed, and store the compiled results to reuse for subsequent requests. 

4.      Rich output caching:It executes the page just once, and saves the result in memory in addition to sending it to the user. The cached result from memory can be used without re-executing the page. 

Thus, ASP.NET combines unprecedented developer productivity with performance, reliability, and deployment.

 

Back End: -                  

SQL SERVER 2005

 

Microsoft SQL Server is an application used to create computer databases for the Microsoft Windows family of server operating systems. It provides an environment used to generate databases that can be accessed from workstations, the web, or other media such as a personal digital assistant (PDA).

 

Enterprise Manager is the main administrative console for SQL Server installations. It provides us with a graphical "birds-eye" view of all of the SQL Server installations on our network. We can perform high-level administrative functions that affect one or more servers, schedule common maintenance tasks or create and modify the structure of individual databases.

 

Query Analyzer offers a quick and efficient method for performing queries against any of our SQL Server databases. It's a great way to quickly pull information out of a database in response to a user request, test queries before implementing them in other applications; create/modify stored procedures and execute administrative tasks.

 

Feature of Microsoft SQL Server 2005

1.      Data Definition Language

2.      Data Manipulation Language

3.      Embedded Data Manipulation Language

4.      View Defining & Authorization

5.      Internet Integrity

6.      Transaction control

7.      Scalability and Availability

 

Requirement and Analysis

 

            Information gathering is usually the first phase of the software development project. The purpose of this phase is to identify and document the exact requirements for the system. The user’s request identifies the need for a new information system and on investigation re-defined the new problem to be based on MIS, which supports management. The objective is to determine whether the request is valid and feasible before a recommendation is made to build a new or existing manual system continues. The major steps are – 

 

1.      Defining the user requirements.

2.      Studying the present system to verify the problem.

3.      Defining the performance expected by the candidate to use requirements.

 

 

Problem Definition

           

            The maintenance of various records and procedure of reporting are being done manually by the counseling department. This leads to many drawbacks some of which are:

1.      It is a time consuming process.

2.      Proper arrangements should be made before and after the examination -which is both money spending and time consuming.

3.      As the number of student’s increases counseling process becomes more and more difficult.

4.      Not globally maintain the information

5.      Evaluation of answer sheets also consumes heavy amount of time.

6.      Difficult to management the all types of information of college or university

7.      Furthermore, manual evaluation is prone to errors.

 

 

 Requirement Specifications

In the proposed software the requirements of the Personal Mobile Assistant are given below:

6.      The proposed system will save significant amount of time and effort invested by the university every year.

7.      It fully works as an online and centralized database maintain all information.

8.      It helps the university to dynamically add records to the database.

9.      Easy to Searching the information about college or university.

10.  Easy to managing whole counseling procedure

 Functional and Non-Functional Requirements

·         Functional Requirements

Following are the functional requirement of the software system:

                                  

1)      User must have a valid roll number which is used to login at the system to start the examination.

 

2)      When one roll number is login then it’s not possible to re-login again and one user can login at only-one system.

 

3)      When the user login then the roll number, name and photo shown at their examination screen till the examination is not completed.

 

4)      User is able to see only previous question (just back) and option to skip and review the question.

 

5)      User can see the result of the exam at end of examination.

6)      All the work is done by using Mouse from entering the roll number to view the result.

7)      Time out facility with warning message of the elapsed time.

8)      Provide the review of each question of the paper.

·                                               Non-Functional requirements

The  non-functional requirements of the software system are:

 

·      Maintainability:

     System should be able to be maintained easily and with no special needs. Most of the maintenance should be done automatically by the system with no interaction by the user.

 

·      Portability:

      System must be able to run on different machines so that it can be better used in   all the machines.

 

·      Extensibility:

      System must be extensible so that future needs can be taken care off.

 

·      Serviceability:

   System must be able to provide durable rendering of its services by taking care of   all required possibilities.

 

 

 

 

 

 

 

 

 

 

 

Software and Hardware Requirements

 

Software Requirement

 

Operating system       : -         Microsoft Windows  

Front-end language   : -         ASP.net3.5(c#)

Back-end                    : -         SQL Server2005    

                       For Documentation   : -         Microsoft Word & Microsoft

                                                                       PowerPoint

 

Hardware Requirement

 

Processor                    : -         Pentium 4

RAM                          : -         128 MB

HDD                           : -         20 GB of free Hard Disk space

Monitor                      : -         15’’ SVGA Monitor

Keyboard                   : -         PS 2 Normal

                        Mouse                         : -         PS 2 Normal

 

Preliminary Project Description

Develop an application for automation of Counseling System though which seats in various courses are allocated to the students.  Students need to give their basic details, three priorities wise list of courses and collage (combination) preference and Rank Number gained in an entrance examination. This application will automatically allocate the seats according to their given preferences of the student and generate the allocated college & batch details for the student. For special purposes administrator can also allot the seats for the students and assign college & batch details

 

 

E-R Diagram

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 DFD

O levelDfd

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1^st LevelDfd

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2^nd LevelDfd

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 Database Description

 

Table 1:- STUDENT_RECORD

Field Name	Data Type	Size
roll_no	Numeric	9
stu_name	Varchar	20
stu_father_name	Varchar	20
stu_add	Varchar	50
stu_city	Varchar	10
stu_state	Varchar	20
stu_country	Varchar	10
stu_dob	Date
username	Varchar	10
password	Varchar	20
rank_no	Varchar	10
Sex	Varchar	2
category	Varchar	5

 

Table 2:- AUTHENTICATION

Field Name	Data Type	Size
roll_no	Numeric	9
stu_name	Varchar	20
stu_rank	Numeric	8

 

 Table 3:-COLLEGE_RECORD

Field Name	Data Type	Size
c_code	Varchar	5
c_Name	Varchar	20
c_add	Varchar	50

 

 

 

Table 4:- COURSES

Field Name	Data Type	Size
course_name	Varchar	20
course_code	Varchar	5
course_duration	Numeric	5

 

Table 5:- SEATS_DETAILS

Field Name	Data Type	Size
c_code	Varchar	5
b_code	Varchar	5
course_code	Varchar	5
total_seats	Numeric	3
allocated_seats	Numeric	3
available_seats	Numeric	3
gen_seats	Numeric	3
obc_seats	Numeric	3
sc/st_seat	Numeric	3

 

Table 6:- STUDENT_PREFERENCE

Field Name	Data Type	Size
roll_no	Numeric	9
preference_no	Numeric	1
c_code	Numeric	5
b_code	Varchar	10
course_code	Varchar	5

 

Table 7:-BRANCH

Field Name	Data Type	Size
b_code	Varchar	10
b_Name	Varchar	20

 

 

Bibliography

1. Software Engineering, Roger S. Pressman, McGraw-Hill 
2. An integrated approach to software engineering, PankajJalote, Narosa Publishing House
3. System Analysis And Design, Elias M Awad, Galgotia Publication
4. Mastering in Asp.Net, EvangelosPetroutsos, BPB Publications
5. Introduction to Sql Server, Kevin Loney& George Koch, Tata McGraw Hill