online counselling system

NATIONAL INSTITUTE OF TECHNOLOGY, KARNATAKASurathkal

AProject Report

on

ONLINE COUNSELING SYSTEM

submitted in partial fulfillment of the requirementsfor the award of the degree of

Bachelor of Technology

in

COMPUTER SCIENCE AND ENGINEERING

by

Ishank Jain - 10CO31Jatin Chauhan - 10CO34Jinesh Jain - 10CO36Mohit Nebhnani - 10CO45Ravi Ranjan - 10CO70

Under the guidance of

Mr. Vivekraj V.KNovember, 2012

DECLARATION

We hereby declare that the Report of the U.G. Project Work entitled”Online Counseling System” which is being submitted to the National Institute ofTechnology Karnataka, Surathkal in partial fulfillment of the requirements for the fifthsemester Database And Management System course of the Bachelor of TechnologyDegree in Computer Science and Engineering in the Department of Computer ScienceEngineering , is a bona-fide report of the work carried out by us. We take thisopportunity to express our deepest gratitude and appreciation to all those studentswho have helped us directly or indirectly towards the successful completion of thisproject:

Roll No Names of Students

10co31 Ishank Jain10co34 Jatin Chauhan10co36 Jinesh Jain10co45 Mohit Nebhnani10co70 Ravi Ranjan

1

CERTIFICATE

This is to certify that this project report is on the project titled ’ONLINE COUNSEL-ING SYSTEM’ by DA VINCI CODERZ. This Project is a part of their Laboratorycourse on Database Management Systems.

DA VINCI CODERZ consists of following TEAM MEMBERS

Ishank Jain - 10CO31Jatin Chauhan - 10CO34Jinesh Jain - 10CO36Mohit Nebhnani - 10CO45Ravi Ranjan - 10CO70

Date : 7th November,2012

Course InstructorMr. Vivek RajLecturerDept. of CSE,NITK

2

ACKNOWLEDGEMENT

Foremost, we would like to express our sincere gratitude to our guides MR.VIVEK RAJ, the current course instructor, Department of Computer Science Engi-neering ,NITK Surathkal.His advice, constant support, encouragement and valuablesuggestions throughout the course of our project work helped us in successful com-pletion of the project. This project drew upon the knowledge and experience of ourguides. Without their continuous support and interest, this report would not havebeen the same as presented here.

We are thankful to MRS. SHANTHI THILAGAM,Prof. at Department of Com-puter Science Engineering for her co-operation and for providing necessary facilitiesthroughout the course. Besides our guides, we would like to thank entire teachingand non-teaching staff in the Department of Computer Science Engineering, NITKfor all their help during our tenure at NITK.

3

Contents

1 INTRODUCTION 11.1 Description . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11.2 Evaluation Of Existing System . . . . . . . . . . . . . . . . . . . . . . 1

1.2.1 Existing System: - . . . . . . . . . . . . . . . . . . . . . . . . 11.2.2 Limitations of the Existing System: - . . . . . . . . . . . . . . 11.2.3 Proposed System: - . . . . . . . . . . . . . . . . . . . . . . . . 21.2.4 Features Of The Proposed System: - . . . . . . . . . . . . . . 3

1.3 Objective Of The Project . . . . . . . . . . . . . . . . . . . . . . . . 31.4 Scope Of The Project . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

2 DESIGN 52.1 Logical Design . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52.2 Data Flow Diagram, Entity Relational Diagram and Relational Schema 52.3 Physical Design . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

2.3.1 GUI Design Tool . . . . . . . . . . . . . . . . . . . . . . . . . 92.3.2 Application Design Tool . . . . . . . . . . . . . . . . . . . . . 102.3.3 Database Design Tool . . . . . . . . . . . . . . . . . . . . . . 11

3 IMPLEMENTATION 133.1 Database SQL Statements . . . . . . . . . . . . . . . . . . . . . . . . 13

4 TESTING 204.1 FIRST ROUND . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204.2 SECOND ROUND . . . . . . . . . . . . . . . . . . . . . . . . . . . . 234.3 THIRD ROUND . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25

5 CONCLUSION 26

6 REFERENCES 276.1 For Various Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 276.2 For Other Information . . . . . . . . . . . . . . . . . . . . . . . . . . 27

i

List of Figures

2.1 DFD Level0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62.2 DFD Level1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62.3 DFD Level2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72.4 ER Diagram . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82.5 Relational Schema . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92.6 Microsoft Visual Studio-2010 . . . . . . . . . . . . . . . . . . . . . . . 102.7 Wamp Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 112.8 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12

3.1 SQL Statements : Students . . . . . . . . . . . . . . . . . . . . . . . 143.2 SQL Statement : Institutes . . . . . . . . . . . . . . . . . . . . . . . 153.3 SQL Statement : Branches . . . . . . . . . . . . . . . . . . . . . . . . 163.4 SQL Statement : Seats . . . . . . . . . . . . . . . . . . . . . . . . . . 173.5 SQL Statement : Choices . . . . . . . . . . . . . . . . . . . . . . . . . 183.6 Allotment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183.7 Do Counseling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193.8 Home Page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19

4.1 ADMIN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204.2 ALLOTMENT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 214.3 SEATS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 214.4 CHECKALLOTMENT . . . . . . . . . . . . . . . . . . . . . . . . . . 224.5 STUDENT STATUS . . . . . . . . . . . . . . . . . . . . . . . . . . . 224.6 ALLOTMENT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 234.7 SEATS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 234.8 Check Allotment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 244.9 UPGRADE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 244.10 ALLOTMENT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25

ii

Chapter 1

INTRODUCTION

1.1 Description

The Online Counseling System is developed to enhance counseling. The software willbe great relief to the students. The Online Counseling System is developing to enhancethe counseling, which fully works as an online. This software will be great relief to thestudent for Reporting, Registration and searching the information about college anduniversity.This software gives an overview of the entire institute in a sort interval timeand will be also great help to University to manage in the whole counseling procedureby there paper work and reducing their time.This project consist fallowing modules.

• Institute record - Covering Details regarding Institute

• Student record - Covering Details regarding Students

• Counseling - Helps in Category wise counseling.

1.2 Evaluation Of Existing System

1.2.1 Existing System: -

Present system or Existing system of Counseling Management System working manu-ally or computerized in a building. Therefore all types works are maintain in building.So to maintain all the counseling procedure is very difficult. If we are reporting, thenwe need go to the University and get a form for reporting and fill the form and sub-mit in the queue conditions. Then verify there form by the university and maintainthe record in computer or register.The system is mainly related to online counselingmanagement system. Which is developing an online web based application system,it is necessary to make a thorough study of the existing system .There is no onlineCounseling Management System. The all the information not maintains globally.Therefore to maintain all the information of university is very difficult.

1.2.2 Limitations of the Existing System: -

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

1

• It is a time consuming process.

• Proper arrangements should be made before and after the examination -whichis both money spending and time consuming.

• As the number of students increases counseling process becomes moreand moredifficult.

• Not globally maintain the information

• Evaluating of answer sheets also consumes heavy amount of time.

• Difficult to management the all types of information of college or university

• Further more, manual evaluation is prone to errors.

1.2.3 Proposed System: -

In proposed system at first reduce the problem, which is faced in Existing Sys-tem. So In the proposed system, Online Counseling System will provide theonline facility for reporting/registration or access any type of information about thecollege/university and globally maintain all the information by the university and thisproject consist fallowing modules are- :-

1. Institute Record: -

Provide the fallowing types of facilities using different options: -

• Insert : This part allow any new institute, if we want to participate incounseling thenenter its details regarding the institute - Institute Code,Name of the institute, Name of the city, Category wise total number ofseats i.e. General Seats, OBC Seats, SC/ST seats.

• Search : It provides Searching for any institute details.- On the basisof its code.- On the basis of its name.

• Delete : If any institute Withdraw from counseling then this part willhelp in deletingthat institute record.

• Display : It will help in displaying complete information about institutecode name, city,and total seats according to category.

2. Student Record: - This module has two parts: -

• Search: This will provide help in searching record of any student who isallotted seats inan institute during counseling procedure.

• Delete: This will allow to deleting record of any student after counseling.The deletioncan be on the basis of Roll no, Name.

3. Counseling : - This is the third and important module .It is divided intocategory wise counseling. So there are three modes of counseling.

2

• General counseling :- Candidates in General Category enter in thiscounseling then he is allotted to see the status of vacant and occupied gen-eral eats in every institute the process STATUS if the satisfied he is allottedseats .In this procedure candidate fill the complete form which includes de-tails Name,Roll No, Rank, Sex, Category, etc.But any Student want towithdraw after allotted the seats then can be withdraw with thehelp indeleting the student record.

• OBC counseling :- Candidates in OBC Category enter in this counselingthen he is allotted to see the status of vacant and occupied general eatsin every institute the process STATUS if the satisfied he is allotted seats .In this procedure candidate fill the complete form which includes details-Name,Roll No, Rank, Sex, Category, etc. But any Student who want towithdraw after allotted the seats then can be withdraw with the helpindeleting the student record .

• SC/ST counseling :- Candidates in SC/ST Category enter in this coun-seling then he is allotted to see the status of vacant and occupied generalseats in every institute the process STATUS if the satisfied he is allottedseats .In this procedure candidate fill the complete form which includesdetails . Name, Roll no, Rank, Sex, Category, etc.But any Student wantto withdraw after allotted the seats then can be withdraw with the help indeleting the student record.

1.2.4 Features Of The Proposed System: -

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

• The proposed system will save significant amount of time and effortinvested bythe university every year.

• The System fully works as an online.

• Centralized maintain all information.

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

• Easy to Searching the information about college or university.

• Easy to managing whole counseling procedure

1.3 Objective Of The Project

Online counseling System is fully work as online using the internet, which is providesfacility online such as- Student Counseling , Managing the student record,Managingthe Institute record and Searching the any other information about Counseling pro-cedure/Institutes, this types of information easy to search through the website .

3

1.4 Scope Of The Project

Types of information Online, and Efficient and systematic maintenance of thehugeDatabase, speeding up queries and faster processing are also be factor for going forthis project.This system is applicable for any other university /Institute, which workas online. The package will require data to be entered in user-friendly forms.Thissystem provide the scope of online working using the internet such as

• Student reporting ,

• counseling ,

• Institute registration for counseling ,

• searching the information of counseling procedure and

• total Seats of college etc.

There are following modules and forms are used-

1. Institute Record.

2. Student Record.

3. Counseling.

4. Categorys selection form.

5. Reporting, Withdraw.

4

Chapter 2

DESIGN

The objective of the system design is to deliver the requirements as specified in thefeasibility report. System design involves first logical design (logical design) andthen physical construction (detailed design) of the system. The logical design de-scribes the structure and characteristics of features, such as the outputs, inputs, files,databases,and procedures. The physical construction produces actual program soft-ware, files, and a working system.System design goes through two phases of develop-ment: -

1. Logical Design2. Physical Design

2.1 Logical Design

We know that a data flow diagram shows the logical flow of a system and definesthe boundaries of the system. Logical design specifies the user need at a level ofdetails that virtually determine the information ow into and out of the system andthe required data resources. Logical design describes the inputs, outputs, databaseand procedures .All in a format that meets the users requirements.

2.2 Data Flow Diagram, Entity Relational Diagram

and Relational Schema

5

Figure 2.1: DFD Level0


6


7

Figure 2.4: ER Diagram

8

Figure 2.5: Relational Schema

2.3 Physical Design

It provides the working system by defining the design specification that tells program-mers exactly what that candidate system must do. In short it can state that physicaldesign is the implementation of the logical design.Physical system design consists ofthe following :-

1. Design the physical system. Specify input, output media.2. Design the database and specify backup procedures.3. Design physical information flow through the system and a physical design walk

through plan system implementation.

2.3.1 GUI Design Tool

Description

Microsoft Visual Studio is an integrated development environment (IDE) from Mi-crosoft. It is used to develop console and graphical user interface applications alongwith Windows Forms applications, web sites, web applications, and web services inboth native code together with managed code for all platforms supported by Mi-crosoft Windows, Windows Mobile, Windows CE, .NET Framework, .NET CompactFramework and Microsoft Silverlight. Visual Studio includes a code editor support-ing IntelliSense as well as code refactoring. The integrated debugger works both asa source-level debugger and a machine-level debugger. Other built-in tools includea forms designer for building GUI applications, web designer, class designer, anddatabase schema designer. It accepts plug-ins that enhance the functionality at al-most every levelincluding adding support for source-control systems (like Subversionand Visual SourceSafe) and adding new toolsets like editors and visual designers fordomain-specific languages or toolsets for other aspects of the software developmentlifecycle (like the Team Foundation Server client: Team Explorer).

9

Reason to Use The Tool

It is a One of the Best Environment which support multiple IDE’s work simul-taneously. It is quite helpful for programmer as it provides help dropdown whichdescribes many functions and attributes constituted in same class.

Figure 2.6: Microsoft Visual Studio-2010

2.3.2 Application Design Tool

Description Of Tools

WampServer is a Windows web development environment. It allows you to create webapplications with Apache2, PHP and a MySQL database. Alongside, PhpMyAdminallows you to manage easily your databases.

WAMP is an acronym formed from the initials of the operating system MicrosoftWindows and the main components of the package: Apache, MySQL PHP.

As a reminder, Apache is the most popular open source web server, MySQL isthe most popular open-source database, used by huge number of websites around theworld (among them, you will find Google, YouTube, Wikipedia, Facebook, Flickr, etc)and PHP is a widely used general-purpose server-side scripting language designed toproduce dynamic web pages.

Reason To Use The Tool

By combining these components into a single installation package, WampServer allowsusers to set up a server locally on their Windows machine to create dynamic webapplications with Apache, PHP and the MySQL database in the same developmentconditions as on the production server.

One of the great benefits of WampServer is that it allows you to develop, upgradecomponents, perform any web development task and carefully test everything offlinefirst, which reduces the risks of creating problems on the live server.

10

Figure 2.7: Wamp Server

2.3.3 Database Design Tool

Description Of The Tool

MySQL5.5.24 is primarily an RDBMS and ships with no GUI tools to administerMySQL databases or manage data contained within the databases. Users may usethe included command line tools, or use MySQL5.5.24 ”front-ends”, desktop softwareand web applications that create and manage MySQL5.5.24 databases, build databasestructures, back up data, inspect status, and work with data records.

The official set of MySQL front-end tools, MySQL Workbench is actively developedby Oracle, and is freely available for use.

Reason To Use The Tool

MySQL is an open source software hence available free of cost. Also it comes in inte-grated version with wamp server which makes it easier to use and it can be combinedwith other development softwares very easily.

11

Figure 2.8: MySQL

12

Chapter 3

IMPLEMENTATION

3.1 Database SQL Statements

13

Figure 3.1: SQL Statements : Students

14

Figure 3.2: SQL Statement : Institutes

15

Figure 3.3: SQL Statement : Branches

16

Figure 3.4: SQL Statement : Seats

17

Figure 3.5: SQL Statement : Choices

Figure 3.6: Allotment

18

Figure 3.7: Do Counseling

Figure 3.8: Home Page

19

Chapter 4

TESTING

4.1 FIRST ROUND

Figure 4.1: ADMIN

20

Figure 4.2: ALLOTMENT

Figure 4.3: SEATS

21

Figure 4.4: CHECKALLOTMENT

Figure 4.5: STUDENT STATUS

22

4.2 SECOND ROUND


Figure 4.7: SEATS

23

Figure 4.8: Check Allotment

Figure 4.9: UPGRADE

24

4.3 THIRD ROUND


25

Chapter 5

CONCLUSION

The ”Online Counseling System” has been developed to solve the various prob-lems which the institute faces when it is working manually. At the same time thissoftware meets the objective to maintain database for future interest.

All the information flows and processes of the system were represented in theform of flow diagrams. By analyzing the flow diagrams, the database was designedwith the consultation of the user of the software. The tables were normalized to reduceredundancy and inconsistency; all the data are stored in the database in the form of2-D relational tables. To perform operations on this database, different programshave been designed and developed. To efficiently carry out the functionality of the”Online Counseling System” , a number of user-friendly forms and reports have beendeveloped. All these forms and reports are linked and invoked by the main form.

The software has been developed keeping in mind the convenience of users.It is developed in such a way that any user without any detailed knowledge of thesystem can handle with a little training. The user interacts with the software of thesystem through the messages displayed at various steps.

It was a wonderful experience doing this project and we learnt a lot whiledoing this project .

We hope for more of such projects in the near future.

26

Chapter 6

REFERENCES

6.1 For Various Tools

1. For Wamp Serverhttp://www.wampserver.com/en/2. For MySql Serverhttp://dev.mysql.com/downloads/installer/3. For Microsoft Visual Studio-2010http://www.microsoft.com/visualstudio/eng/downloads

6.2 For Other Information

1. http://www.google.com/2. http://www.wikipedia.org/3. http://www.w3schools.com/4. http://www.stackoverflow.com/5. Fundamentals Of Database Systems By Elmasri And Navathe6. Database System Concepts By Abraham Silberschatz And Henry F. Korth.7. ACTIVE SERVER PAGES 3.0 UNLEASHED – Steven Walter , (Techmedia

SAMS) Steven Banick , Aaron Bertrand8. TEACH YOURSELF ACTIVE SERVER PAGES 3.0 – Scott Mitchell (Tech-

media SAMS) James Atkinson9. USING ACTIVE SERVER PAGES – Scot Jhonson – Keith Ballinger – Davis

Chapman10. ADVANCED .NET PROGRAMMING – Yehuda Shiran – Tomer Shiran11. SQL 8.0 COMPLETE REFERENCE – George Koch (TMH, oracle press)

Kevin Loney12. SQL PROGRAMMING – Scott Urman

27

online counselling system

Documents