Project Report

On
Student Record Management System
Submitted by
Madhusmita Hati(18CSC011)
Truptimayee Sahoo(18CSC031)
Sarita Behera(18CSC022)

Under the Guidance of

Mr.Dilip Kumar Nayak(H.O.D)
Dept.ofComputer Science

Submitted To
Dept.of Computer Science
Dhenkanal Autonomous College
(In partial fulfilment of the requirement for the award of the degree of B.Sc Computer Science during
the session 2018-2021)
 Declaration
We hereby declare that the project report entitled , “STUDENT RECORD MANAGEMENT SYSTEM”
submitted by my group to the Department of Computer Science,Dhenkanal Autonomous College ,
Dhenkanal, Odisha in partial fulfilment for the award of the degree of B.Sc Computer Science
during academic session 2020-2021 is an authentic record of our own work carried out under the
guidance of Mr.Dilip Kumar Nayak(H.O.D),Dept.of Computer Science and that the project has not
previously formed the basis for the award of any other degree.the report has been prepared in
compliance to the guideline specified by the college.

Place:Dhenkanal Truptimayee Sahoo(18CSC031)

Date: Sarita Behera(18CSC022)
Madhusmita Hati(18CSC011)
 CERTIFICATE
This is to certify that the project entitled “ STUDENT RECORD MANAGEMENT
SYSTEM” submitted for partial fulfilment of Bachelor Degree in Computer Science of Dhenkanal
Autonomous College,Dhenkanal by Madhusmita Hati(18CSC011),
Sarita Behera(18CSC022),Truptimayee Sahoo(18CSC031) during the academic session is a bonafide
work and has been carried out in this department under my supervision and guidance.

H.O.D
Computer Science Supervisor
 Acknowledgement
At the outset ,We express our most sincere grateful thanks to our guide Mr.Dilip
Kumar Nayak(H.O.D) for his continuous support and valuable advice not only during the course of our
project but also providing necessary and related facilities required for the compilation of the project
of the project file.
We also thankful to Mrs.Sasmita Pradhan ,Dept.of Computer Science who assisted us
throughout project and Mr.Debasish Pattnaik who has beeb kind enough to support us in the project.
Finally,we would like to thank my friends for their cooperation to complete this
project.

Submitted by:-
Name:Madhusmita Hati Submitted to:-
Exam Roll No:18CSC011 Department of Computer Science
Roll no:BS-18-032 Dhenkanal Autonomous College
Name: Truptimayee Sahoo Dhenkanal
Exam Roll No:18CSC031
Roll No:BS-18-217
Name:Sarita Behera
Exam Roll No:18CSC022
Roll No:BS-18-049
 ABSTRACT
Student Record Management System is a project which aims in
developing a computerized system to maintain all the details information of the
students of an institution. This projects has many features which are generally
not available in normal record management system like student login.It also has
the feature of Admin login through which the administrator can monitor the
whole system.It has a functionality where student after logging into their id’s
can see the details information about his/her by giving entry id and the
corresponding password. The Administrator after logging into his id i.e,ta login
can generate various reports like student details record, grade record ,courses
record etc. On the whole, this project of ours is being developed to help the
students as well as staff of the academic section to maintain the records in the
best way possible and also to reduce the manual.
 CONTENTS
1. Introduction
1.1.Aim
1.2.Scope
2. Objective of the project
3. Problem Description
4. The overall Description
4.1. Product prospective
4.2. Product Function
4.3.User Characteristic
4.4.Assumption and Dependencies
5. System Analysis
5.1. Introduction
5.2. Existing System
5.2.1. Disadvantage of Existing System
5.2.1.1. Not user friendly
5.2.1.2. Difficulty in Report Generating
5.2.1.3. Manual Control
5.2.1.4. Loss of Paperwork
5.2.1.5.Time Consuming
5.3. Proposed System
5.3.1. Advantages of Proposed System
6.Feasibility Analysis
6.1. Feasibility Study
6.1.1. Technical Feasibility
6.1.2. Economical Feasibility
6.1.3. Operational Feasibility
7.Requirement Specification
7.1. Hardware Requirements
 7.2. Software Requirement
7.3. Functional Requirement
7.4. Usecase Diagram
7.5.Nonfunctional Requirement
7.5.1. Performance
7.5.2. Reliability
7.5.3. Availability
7.5.4. Security
7.5.5. Maintainability
7.5.6. Portability
7.6. Design Constraint
8.Design
8.1.DFD
8.2. Class Diagram
8.3. ER Diagram
9.Coding
10.Testing and Debugging
10.1. Introduction
10.2. Testing Methodology
10.3. Unit Testing
10.4. System Testing
10.5. Performance Testing
11.System Maintenance
12.Future Enhancement
13.Output Screenshots
14.Conclusion
15.Bibliography
1.INTRODUCTION
Student Record Management System is an environment where all the record of students in the
institution is managed. It is done through the automated computerized method.Conventionally this
system is done using papers, file and binders.
This system saves the time of the student and of the administrator.It includes process like registration
of the student , showing details of student ,adding course,grade records etc.based on their
maintenance records.
This system reduces the cost and workforce required for this job.It is easy to handle and updating at
the same time. The project intends to introduce more user friendliness in the various activities such
as record updation,maintenance and searching can be accomplished by using the ID and password of
the student with all the details being automatically generated.These details are also being promptly
automatically updated in the master file thus keeping the record absolutely up-todate.
1.1 Aim:-
The aim of the developing web based student record management system is to computerized the
tradition way of keeping records .Another purpose of developing this software is to generate the
report easily by the administrator and also the students are able to know their details like
grade,mark,course etc.by using the specific ID and password of own.

1.2Scope:-
The scope of the project is the system in which the software is installed ,i.e,the project is developed
as a website,and it will work for a particular institute.But later on the project can be modified to
operate it online after hosting it.

2.Objective of the Project:-

Effective student record system use computer technology to maintain longitudinal information about
individual students served within an education system.Description of a student record system.
Students records are often viewed as paperwork produced for the education bureaucracy.
It control the quality and quantity of records.Simplify the activities,systems and
processes of records.
This details are also being promptly automatically updated thus keeping the record
absolutely up-to-date.
The main objective of the project is providing the different typed of student and
administrator facility.The main objective of the system is to findout the actual customer service.Etc.
 It should fulfil almost all the process requirements of any educational institution.
 It should decrease the time and cost for maintain record as well as with minimum manpower.
This project includes the entire upgraded feature required for the computerization Student Record
Management System.This system is very easy to use,so that any student can use without getting
preknowledge about this.It is very user friendly and meet almost all record keeping working process
requirements.This system is melded in such a way that has got a features to upgrade without making
change in existing components.

3.PROBLEM DESCRIPTION:-
The Student Record Management System is an application for maintaining the details information of
all the students of an institution.The system provides the acess to the student to login,view their
grades,marks,subjects from his ID.The following documentation provides the specification of the
system.
We are mainly concerned with developing a Student Record Management System where a
student can register and can also his/her marks,grades,subjects etc.One can easily maintain the above
things if he/she has an ID by register through his uniqueID and password.

4.THE OVERALL DESCRIPTION

4.1 Product Perspective:
The product Record Management System is an independent product and does not depend on any
other product or system.The product will automate various tasks associated with handling student
details and better organizing the stored information and optimum performance,thus helping the
colleges to ensure smooth working of these process.

4.2 Product Function:

Our systems has two types of accessing modes:
1.Administrator
2.User(student) 1.Administrator
 Administrator have rights to manage student details,add a new student,provide register ID for all
student ,assign each student a course etc.Administrator can update his profile and also can give help.
2.User
Student do the logins and profile,marks,grades etc.
4.2.1User Characteristics-
This software gives access to two kinds of users.
1.Administrator:
The administrators have features access to add,delete,and modify information stored in the
database.
2.Authorized User:
Student have access to view their details and register as a new student.

4.3Constraints:
Interface is only in English,no other language option is available.

User can login with his assigned ID and password,no guest facilities is available.

4.4Assumption and Dependencies:

We assume that the office personnel do all the data entry based and correct values obtained from
forms and registers.
We assume that the computer will use the software will be part of the college LAN.
Users with administrators access should br careful in deleting or modifying any information knowingly
or unknowingly which lead to inconsistency of the database.

The end user of this software are assumed to have basic level of computer knowledgei.e,point and
click.

5.SYSTEM ANALYSIS
5.1Introduction:
Analysis can be defind as breaking up of any whole so as to find out their nature,function etc.It defines
design as to make preliminary sketchs of ,to sketch a pattern or outline for plan.To plan and carry out
especially by artistic arrangement or in skilfulwall.System analysis and design can be characterized as
a set of techniques and processes,a community of interests, a culture and an intellectual
orientation.The various tasks in the system analysis include the following.

• Understanding Application
• Planning
• Scheduling
• Developing candidate solution
• Performing trade studies
• Performing cost benefits analysis
• Recommending alternative analysis
• Supervising,installing and maintaining the system
This system manages to the analysis of the report creation and developes manual entry of the student
detais information .First design the students entry form,view details like marks,grades etc.This
projects will help the record management system for the department calculate grades for reports
eligibility criteria of examinations through marks.The application student record system will provide
flexible reports for all students.

5.2Existing System:
In the existing system all work has done by manually.The whole session record is stored in registers
and at the end of the session or as per the required because it takes more time in findings.
5.2.1Disadvantages of Existing System:
• 5.2.1.1Not User Friendly:
The existing system is not user friendly because the retrival of the data is very slow and data is
not maintained efficiently.
• 5.2.1.2Difficulty in report generating:
We require more times to generate the report so it is generated at the end of the session.And
the students not get a single chance to improve their marks and grades.
• 5.2.1.3Manual Control:
All processes to generate report is done manually so there is greater chance of losing records.
• 5.2.1.4Lots of paperwork:
Existing system requires lot of paperwork.Loss of even a single register /record led to difficult
situation because all the papers are needed to generate reports.
• 5.2.1.5Time consuming:
Everywork is done manually so we cannot generate report in the middle of the session or as
per the requirement because it is very time consuming.

5.3Proposed System:
To overcome the drawbacks of the existing system ,the proposed system,has been
evolved.This project aims to reduce the paperworks and saving times to generate accurate
results from the student records.The system provides with the best user interface.
5.3.1Advantages of proposed system:
It is trouble-free to use.

It is a relatively fast approach to store records is highly reliable,approximate result from user
best user interface and efficient reports.
6.FEASIBILITY ANALYSIS:-
Depending on the results of the initial investigation,the survey is expanded to a more detailed
feasibility study.A feasibility study is a test of a system proposal.According to its workability,impact on
the organization ,ability to meet user’s needs and effective uses of the resources its main task done
during the feasibility study are:-
Evaluation of existing system and procedures.Our group went to various administrator professionals
to gather information about the software system.They are using and evaluating those system and the
procedures invoked in it during the feasibility study.
Analysis of alternative candidate systems after studying the various systems we derives various
alternatives through which we develop our project and evaluated the alternatives.The most
appropriate is selected.
6.1Feasibility study:
The only tangible benefit provided by the proposed systm is that the paper work is reduced to the
minimum and hence the reduction in cost incurred on ststionary and its storage.The system provides
many benefits that can’t be measured in terms of money for e.g.user’s friendliness,more user
response being more efficient.
6.1.1Technical feasibility-
The proposed system is technical feasible as it can be developed easily with the help of available
technology.The proposed system requires java programming language and mysql with java database
connectivity to connect with the database.,which is easily available and also economically feasible.
6.1.2Economical feasibility-
The system being developed is economic with respect to any educational institution’s point of view.It
is the cost effective in the sense that has eliminated the paper work completely.
6.1.3Operational feasibility-
Automation makes our life easy.The proposed system is highly user friendly and is much easily able to
interact with the system.Therefore the users are readily accept the system as data entry and
statements can be easily done.

7.REQUIREMENT SPECIFICATION
7.1Hardware requirements:
RAM: 256GB
Hard disk: 500GB
Processor: Intelcore i3/i5
7.2Software requirements:
Operating System: WINDOWS 7/8/10,LINUX
Database: MYSQL
Server: Apache

7.3Functional Requirements:
Record Management System involves the following functions:
Easily access records of students.
Quickly produce details view report.

7.4Usecase Diagram:

DELETE STUDENT

VIEW DETAILS

UPDATE DETAILS

Student Administrator
GENERATEREPORT

EXIT

7.5Non-Functional eequirements:
7.5.1Performance:
Easy tracking of records and updating can be done.All the requirements relating
to performance characteristics of the system are specified in the section below.There are two
types of requirements :
1.Static requirements:

These requirements do not impose any constraints on the execution characteristics of the
system.They are:
Number of Terminals:

The software make use of an underlying database that will reside at the serve,while the
frontend will available to the administrative and departmental computers as well as students.
2.Dynamic Requirements:

These specify constraints on the execution characteristics of the system.They typically include
response time and throughout of the system.Since these factors are not applicable
To the proposed software ,it will suffice if the response time is high and the transactions are
Carried out preciously and quickly.
7.5.2Reliability:
The software will not be able to connect to the centralized database in the event that the
college LAN fails or in the event of the server being down due to a hardware or software
failure.
7.5.3Availability:
The software will be available only to authorized users to the college like administrator to
add students,update students,adding their marks etc.and student to view their details and
marks. 7.5.4Security:
The security requirements deal with the primary security.The software should be handled
only by the administrator and authorized users.Only the administrator has right to assign
permission like adding new students and generating passwords.Only authorized users can
access the system with user ID and password.
7.5.5Maintainability:
Backups for database are available.
7.5.6Portability:
The software is a windows based application and is built in java and MYSQL so it is platform
independent and is independent of operating system.

7.6Design Constraints:
This software provides security..The login form prevents the system for being misused by
unauthorized operator will be granted rights to modify as per requirements .This software is
also reliable and fault tolerant.The system developed and designed to handle invalid inputs.
Since reliability is major area of concerns the systems has a backup to avoid dataloss.The user
should know the programming language very well that is used to develop software.

8.DESIGN:
8.1Data Flow Diagram:

0-level DFD:
 User/Admin

Record portal

Output

1-level DFD

Login
Process
Report generate

Details entry

Student entry
Admin entry
 2-level DFD

Admin

Login process
Admin

Admin entry Student entry

DEGR NAM
D_NAM

STU_I

DOB COLLEG
STUDENT DEPARTMENT

ADDRES MAJOR

IN
8.3ER DIAGRAM
9.CODING
Import java .io.IOException;
Import java.util.scanner;
Import java.sql;
Public class DBDemo
{
static int i=0; static
int sub_id; static String
name; static int credit;
static String ID; static Sting
pass; static String Type;
static String EntryNo; static
String stu_name; static
String dept; static String
degree; static String dob;
static int[]AssID=new int[2];
static int[]Marks=new int[2];
static final String JDBC_DRIVER=”com.mysql.jdbc.Driver”;
static final String DB_URL=”jdbc:mysql://localhost:3306/”;
static final USER=”root”; static final String
PASS=”madhusmita”; static Connection con=null;
static Statement stmt=null; static ResultSet rs=null;
static Scanner in=new Scanner(System.in);

public static void Checkdb(String dbName)

{
try
{
Class.forName(JDBC_DRIVER);
String url=DB_URL;
 con=DriverManager.getConnection(DB_URL,PASS);
System.out.println(“URL:+url);
System.out.println(Connection:”+con);
stmt=con.createStatement();
rs=con.getMetaData().getCatalogs(); int
x=0; while(rs.next())
{
String databaseName=rs.getString(1);
If(databseName.equals(dbName))
{
System.out.println(“Database already exists”+dbName);
x=1;
}
}
if(x==0)
{
stmt.executeUpdate(“CREATE DATABASE stu”);
System.out.println(“Created Successfully”);
}
}
catch(SQLException e)
{
System.out.println(“Error in SQLQuery!”);

System.err.println(e);
e.printStackTrace(); }
catch(ClassNotFoundException e)
{
System.out.println(“Error inClass!”);
System.err.println(e);
e.printStackTrace();
}
}
public static void Checktables(String dbName)throws IOException,ClassNotFoundException
{
DatabaseMetaData dbm;
try

{
 Class.forName(JDBC_DRIVER);
String url=DB_URL;
url=url+dbname;
con=DriverManager.getConnection(url,USER,PASS);
System.out.println(“URL:”=+url);
System.out.println(“Connection:”+con);
stmt=con.createStatement();
dbm=con.getMetaData();
rs=dbm.getTables(dbName,”%”,”login”,null);
if(rs.next())
{
System.out.println(“Table exists:LOGIN”);
}
else if(!rs.next())
{
String sql=”CREATE TABLE login”+”(EntryID VARCHAR(255)NOT
NULL,”+
“Pass VARCHAR(255)NOTNULL,”+
“Type VARCHAR(255),”+
“PRIMARY KEY(EntryID))”;
stmt.executeUpdate(sql);
System.out.println(“Created table in given database…”);
}
rs.close();
rs=dbm.getTables(dbName,”%”,”student”,null);
if(rs.next())
{
System.out.println(“Table exists:STUDENT”);
}
else if(!rs.next())
{
String sql=”CREATE TABLE student”+
“(EntryID VARCHAR(255)NOT NULL,”+
“Stu_name VARCHAR(255),”+
“Dept VARCHAR(255),”+
“Degree VARCHAR(255),”+
“DOB VARCHAR(255),”+
“FOREIGN KEY(EntryID)REFERENCES login(EntryID)
ON DELETE CASCADE)”; stmt.executeUpdate(sql);
 System.out.println(“Created table in given database…”);
}
rs.close();
rs=dbm.getTables(dbName,”%”,”subject”,null);
if(rs.next())
{
System.out.println(“Table exists:SUBJECT”);
}
else if(!rs.next())
{
String sql=”CREATE TABLE subject”+
“EntryID VARCHAR(255)NOT NULL,”+
“SubjectID INTEGER NOT NULL,”+
“Subject_name VARCHAR(255),”+
“Credits INTEGER,”+
“PRIMARY KEY(EntryID,SubjectID),”+
“FOREIGN KEY(EntryID)REFERENCES login(EntryID)
ON DELETE CASCADE)”; stmt.executeUpdate(sql);
System.out.println(“Created table in given database…”);

}
rs.close();
rs=dbm.getTables(dbName,”%”,”marks”,null);
if(rs.next())
{
System.out.println(“Table exists:Marks”);
}
else if(!rs.next())
{
String sql=”CREATE TABLE marks”+
“(EntryID VARCHAR(255)NOT NULL,”+
“SubjectID INTEGER NOT NULL,”+
“AssignID INTEGER NOT NULL,”+
“Marks INTEGER,”+
“PRIMARY KEY(EntryID,SubjectID,AssignID),”+
“FOREIGN KEY(EntryID)REFERENCES login(EntryID)
ON DELETE CASCADE,”+
 “FOREIGN KEY(EntryID,SubjectID)REFERENCES
subject(EntryID,SubjectID)ON DELETE CASCADE)”;
stmt.executeUpdate(sql);
System.out.println(“Created table in given database…Marks”);
}
rs.close();
rs=dbm.getTables(dbName,null,”Grades”,null);
if(rs.next())
{
System.out.println(“Table exists:Grades”);
}
else if(!rs.next())
{
String sql=”CREATE TABLE Grades”+”(EntryID VARCHAR
(255)NOT NULL,”+”SubjectID INTEGER NOT NULL,”
+”TotalMarks INTEGER,”+”Grades varchar(255),”+
“PRIMARY KEY(EntryID,SubjectID),”+
”FOREIGN KEY(EntryID)REFERENCES login
(EntryID)ON DELETE CASCADE,”+”FOREIGN
KEY(EntryID,SubjectID)REFERENCES
subject(EntryID,SubjectID)ON DELETE CASCADE)”;
stmt.executeUpdate(sql);
System.out.println(“Created table in given database…
Grades”);
}
rs.close();
}
catch(SQL Exception e)
{
System.out.println(“Error in SQL Query!”);
System.err.println(e); e.printStackTrace();
}
}

public static void main Studentlogin(String dbName)throws IOException

{
try
{
Class.forName(JDBC_DRIVER);
String url=DB_URL;
 url=url+dbName;
con=DriverManager.getConnection(url,USER,PASS);
System.out.println(“URL:+url);
System.out.println(“Connection:”+con); stmt=con.createStatement();
Statement stmt1=con.createStatement();
Statement stmt2=con.createStatement();
Statement stmt3=con.createStatement();
System.out.println(“Welcome Student!”);
System.out.println(“Enter your ID!:”);
ID=in.next();
rs=stmt.executeQuery(“SELECT*from login where EntryID=’’’ +ID+’””);
while(rs.next())
{
System.out.println(“Enter your password!:”);
pass=in.next();
if(ID.equals(rs.getString(“EntryID”)&&pass.equals(rs.getString(“Pass”))&&
rs.getString(“Type”).equals(“Student”))
{
System.out.println(“Sucessfully login!”);
System.out.println(“1.add course to student”);
System.out.println(“2.remove course to student”);
System.out.println(“3.displaying Grade information”);
System.out.println(“4.change
password”); System.out.println(“5.EXIT”);
int choice=in.nextInt(); if(choice==1)
{
System.out.println(“Enter SubjectID”);
int SubjectID=in.nextInt();
System.out.println(“Enter Subject Name”);
String Name=in.next();
System.out.println(“Enter Subject Credits”);
int Credits=in.nextInt();
stmt.executeUpdate(“INSERT INTO subject VALUES(‘’’+ID+’’’,
‘’’+SubjectID+’’’,’’’+Name+’’’,’’’+Credits+’’’)”);
rs=stmt.executeQuery(“SELECT*from subject where EntryID=’’’+
ID+’’’”);
While(rs.next())
{
 sub_id=rs.getInt(“SubjectID”);
name=rs.getString(“Subject_name”);
credit=rs.getInt(“Credits”);
System.out.println(“EntryID:\t”+ID+SubjectID:\t”+sub_id+”\t
+”\tSubjectName:\t”+name+”\tCredits:\t”+credit);
}
rs.close(); return;
}
else if(choice==2)
{
System.out.println(“Enter SubjectID”);
int SubjectID=in.nextInt();
ID=rs.getString(“EntryID”);
stmt.executeUpdate(“DELETE from subject where SubjectID=’”
+SubjectID+’””);
rs=stmt.executeQuery(“SELECT*from subject where EntryID=’”
+ID+””’);
while(rs.next())
{
sub_id=getInt(“SubjectID”);
name=rs.getString(“Subject_name”);
credit=rs.getInt(“Credits”);
System.out.println(“EntryID=”+ID+”SubjectID:\t”+sub_id+”
\tSubject Name:\t”+name+”\tCredits:\t”+credit);
}
rs.close();
return;
}
else if(choice==3)
{
rs=stmt1.executeQuery(“SELECT M.EntryID as id,SUM(M.Marks)
as total,S.SubjectID as sub_id,S.Subject_name as name from marks
M,subject S where M.EntryID=”’+ID”’”);
While
{
String
entry=rs.getString(“id”);
sub_id=rs.getInt(“sub_id”);
int m=rs.getInt(“total”);
name=rs.getString(“name”);
 System.out.println(“EntryID:\t”+entry+”SubjectID:\t”+sub_id+”
\tMarks:\t”+m+”\tSubject name:\t”+name);
rs.stmt2.executeQuery(“SELECT Count(*)as c from Grades where
EntryID=”’+entry+”’AND SubjectID=”’+sub_id+”’”);
while(rs.next())
{
String Grade;
int count=rs.getInt(“c”);
if(count>=1)
{
System.out.println(“already present”);
}
else
{
If(m>=80)
{
Grade=”A”;
System.out.println(“A”);
}
else if(m>=72)
{
Grade=”A-”;
System.out.println(“A-”);
}
else if(m>=64)
{
Grade=”B”;
System.out.println(“B”);
}
else if(m>=56)
{
Grade=”B-”;
System.out.println(“B-”);
}
else if(m>=48)
{
Grade=”C”;
System.out.println(“C”);
}
else if(m>=40)
 {
Grade=”C-”;
System.out.println(“C-”)
}
else if(m>=32)
{
Grade=”D”;
System.out.println(“D”);
}
else
{
Grade=”F”;
System.out.println(“F”);
}
stmt.executeUpdate(“INSERT into Grades values(“’+entry+”’”’+sub_id+”’+
M+”’,”’+Grade+”’)”);
System.out.println(“EntryID:”+entry+”SubjectID:”+sub_id+”Marks”+m+”Gra
des”+Grade);
}
}
}
rs.close(); return;
}
else if(choice==4)
{
System.out.println(“Enter the new password”);
pass=in.next();
stmt.executeUpdate(“UPDATE login set Pass=”’+pass+”’where
EntryID=”’+ID+”’”);
rs=stmt.executeQuery(“SELECT*from login where EntryID=”’+ID+”’”);
while(rs.next())
{
ID=rs.getString(“EntryID”);
pass=rs.getString(“Pass”);
System.out.println(“EntryID=”+ID+”Pass=”+pass);
}
rs.close();
return;
}
else if(choice==5)
 {
System.out.println(“exit”);
return;
}
else
{
System.out.println(“Wrong Choice!!!”);
Studentlogin(dbName)
}
rs.close();
}
else
{
System.out.println(“Login failed!”);
Studentlogin(dbName);
}
}
}
catch(SQLException e)
{
System.out.println(“Error inSQL Query!”);
System.err.println(e); e.printStackTrace();
}
catch(ClassNotFoundException e)
{
System.out.println(“Error in class!”);
System.err.println(e);
e.printStackTrace();
}
}
public static void main talogin(String dbName)throws IOException
{
try
{
Class.forName(JDBC_DRIVER);
String url=DB_URL;
url=url+dbName;
con=DriverManager.getConnection(url,USER,PASS);
System.out.println(“URL:”+url);
 System.out.println(“Connection:”+con);
stmt=con.createStatement(rs.TYPE_SCROLL_INSENSITIVE,rs.CONCUR_UPDATABLE);
Statement stmt1=con.createStatement(rs.TYPE_SCROLL_INSENSITIVE,
rs.CONCUR_UPDATABLE);
Statement stmt=con.createStatement(rs.TYPE_SCROLL_INTENSIVE,rs.CONCUR_
UPDATABLE);
System.out.println(“Welcome TA!”);
System.out.println(“Enter your TA-ID:”);
ID=in.next();
rs=stmt.executeQuery(“SELECT*fromlogin where EntryID=”’+ID+””’);
while(rs.next())
{
System.out.println(“Enter your password!:”);
Pass=in.next();
If(ID.equals(rs.getString(“EntryID”))&&pass.equals(rs.getString(“Type”).equals(“TA”))
{
System.out.println(“Sucessfully login!”);
System.out.println(“1.giving marks”);
System.out.println(“2.change password”);
System.out.println(“3’exit”); int
choice=in.nextInt(); if(choice==1)
{
System.out.println(“Enter SubjectID”);
int SubjectID=in.nextInt(); int num1=0;
rs.stmt1.executeQuery(“SELECT C0UNT(SubjectID)as num from subject where
(SubjectID )as num from subject where Subject ID=’”+SubjectID+””’);
while(rs.next())
{
num1=rs.getInt(“num”);
System.out println(“num:”+num1);
}
rs=stmt2.executeQuery(“SELECT*from subject where SubjectID=”’+
SubjectID+”’”);
while(num1>0)
{
while(rs.next())
{
System.out.println(“in”);
ID=rs.getString(“EntryID”);
 System.out.println(“ID:”+ID);
System.out.println(“enter marks of 2 assignments for student’s subject”);
For(i=0;i<2;i++)
{
System.out.println(“Enter the assignment ID”);
AssID[i]=in.nextInt();
System.out.println(“Enter the marks”);
Marks[i]=in.nextInt();
stmt.executeUpdate(“INSERT into marks values(“’+ID+”’,”’+SubjectID
+”’,”’+AssID[i]+’”+,”’+Marks[i]+”’)”);
System.out.println(“mmm”);
}
Num1--;
}
}

}
else if(choice==2)
{
System.out.println(“Enter the new password”);
pass=in.next();
stmt.executeUpdate(“UPDATE login set Pass=’”+pass+”’where EntryID=”’+ID
+””’);
rs=stmt.executeQuery(“SELECT*from login where EntryID=”’+ID+””’);
while(rs.next())
{
ID=rs.getString(“EntryID”);
pass=rs.getString(“Pass”);
System.out.println(“EntryID=”+ID+”Pass=”+pass);
}
rs.close();
return;
}
else if(choice==3)
{
System.out.println(“exit”);
return;
}
else
{
 System.out.println(“Wrong choice!!”);
talogin(dbName);
}
} else
{
System.out.println(“Enter correct password”);
talogin(dbName);
}
}
}
catch(SQLException e)
{
System.out.println(“Error inSQL Query!”);
System.err.println(e);
e.printStackTrace();
}
catch(ClassNotFoundException e)
{
System.out.println(“Error in Class!”);
System.err.println(e);
e.printStackTrace();
}
}
public static void signin(String dbName)throws IOException
{
try
{
Class.forName(JDBC_DRIVER);
String url=DB_URL;
url=url+dbName;
con=DriverManager.getConnection(url,USER,PASS);
System.out.println(“URL:”+url);
System.out.println(“Connection:”+con);
stmt=con.createStatement();
System.out.println(“Enter the IDNumber!”;)
ID =in.next();
System.out.println(“Enter Password”);
pass=in.next();
 System.out.println(“Student/TA”);
Type=in.next();
stmt.executeUpdate(“INSERT into login Values(“’+ID+”’,’”+pass+’”,”’+Type+”’)”);
System.out.println(“Sign In Done!”);
If(Type.equals(“Student”))
{
System.out.println(“Enter your nsme!”);
stu_name=in.next();
System.out.println(“Enter your department”);
dept=in.next();
System.out.println(“Enter your degree”);
degree=in.next();
System.out.println(“Enter your DOB”);
dob=in.next();
stmt.executeUpdate(“INSERT into student Values(“’+ID+”’,”’+stu_name+’”,
“’+dept+”’,”’+degree+”’,’”+dob+”’)”);
System.out.println(“Completed Sign In Process”);
Studentlogin(dbName);
}
else if(Type.equals(“TA”))
{
talogin(dbName);
}
return;
}
catch(ClassNotFoundException e)
{
System.out.println(“Error in class!”);
System.err.println(e);
e.printStackTrace();
}
catch(DQL Exception e)
{
System.out.println(“Error in SQL Query!”);
System.err.println(e);
e.printStackTrace();
}
}
public static void search(String dbName)throws IOException
 {
try
{
Class.forName(JDBC_DRIVER);
String url=DB_URL; url=url+dbName;
con=DriverManager.getConnection(url,USER,PASS);
System.out.println(“URL:+url”);
System.out.println(“cConnection:”+con); stmt=con.createStatement();
System.out.println(“How you want to search?\n1.SubjectID\n2.Student Name\n
3.Department\n4.Degree\n5.DOB\n6.Exit”);
int Search=in.next(); if(Search==1)
{
System.out.println(“Enter the EntryID.”);
String No=in.next();
rs=stmt.executeQuery(“SELECT*from student where EntryID=”’+No+”’”);
while(rs.next())
{
EntryNo=rs.getString(“EntryID”);
stu_name=rs.getString(“Stu_name”);
dept=rs.getString(“Dept”); degree=rs.getString(“Degree”);
dob=rs.getString(“DOB”);
System.out.println(“EntryNo:\t”+EntryNo+”\tStudent
Name:\t”+stu_name+ “\tDepartment:\t”+dept+”\tDegree+”\tDOB:\t”+dob);
} rs.close();
search(dbName);
}
else if(Search==2)
{
System.out.println(“Enter the Student Name.”);
String No=in.next();
rs=stmt.executeQuery(“SELECT *from student where Stu_name=’”+No+”’”);
while(rs.next())
{
EntryNo=rs.getString(“EntryID”);
stu_name=rs.getString(“Stu_name”);
dept=rs.getString(“Dept”);
degree=rs.getString(“Degree”);
dob=rs.getString(“DOB”);
 System.out.println(“EntryNo:\t”+EntryNo+”\tStudent Name:\t”+
Stu_name+”\tDepartment:\t+dept+”\tDegree:\t”+degree+”\tDOB:\t”+
dob);
}
rs.close();
search(dbName);
}
else if(Search==3)
{
System.out.println(“Enter the Department Name.”);
String No=in.next();
rs=stmt.executeQuery(“SELECT*from student where Dept=”’+No+”’”);
while(rs.next())
{
EntryNo=rs.getString(“EntryID”);
stu_name=rs.getString(“Stu_name”);
dept=rs.getString(“Dept”); degree=rs.getString(“Degree”);
dob=rs.getString(“DOB”);
System.out.println(“EntryNo:\t”+EntryNo+”\tStudent Name:\t”+stu
_name+”\Department:\t”+dept+”\tDegree:\t”+degree+”\tDOB:\t”+dob);
}
rs.close();
search(dbName);
}
else if(Search==4)
{
System.out.println(“Enter the Degree Name.”);
String No=in.next();
rs=stmt.executeQuery(“SELECT*from student where degree=’”+No””’);
while(rs.next())
{
EntryNo=rs.getString(“EntryID”);
stu_name=rs.getString(“Stu_name”); dept=rs.getString(“Dept”);
degree=rs.getString(“Degree”); dob=rs.getString(“DOB”)
System.out.println(“EntryNo:\t”+EntryNo+”\tStudent
Name:\t”+stu_name+”\tDepartment:\t”+dept+”\tDegree:\t”
+degree+”\tDOB:\t”+dob);
}
rs.close();
 search(dbName);
}
else if(Search==5)
{
System.out.println(“Enter the Date of Birth(DD/MM/YYYY).”);
String No=in.next();
rs=stmt.executeQuery(“SELECT*from student where DOB=”’+No”’”);
while(rs.next())
{
EntryNo=rs.getString(“EntryID”);
stu_name=rs.getString(“Stu_name”);
dept=rs.getString(“Dept”);
degree=rs.getString(“Degree”);
dob=rs.getString(“DOB”);
System.out.println(“EntryNo:\t”+EntryNo+”\tStudent Name:\t”+stu
_name+”\tDepartment:\t”+dept+”\tDegree:\t”+degree+”\tDOB:\t”+dob);
}
rs.close();
search(dbName);
}
else if(Search==6)
{
System.out.println(“Existing……….!”);
return;
}
else
{
System.out.println(“Wrong choice!!”);
search(dbName);
}

}
catch(IOException e)
{
System.out.println(“Error inIO!”);
System.err.println(e);
e.printStackTrace();
}
catch(ClassNotFoundException e)
 {
System.out.println(“Error in Class!”);
System.err.println(e);
e.printStackTrace();
}
catch(SQLException e)
{
System.out.println(“Error inSQL Query!”);
System.err.println(e);
e.printStackTrace();
}
}
public static void Menu1(String dbName)
{
try
{
System.out.println(“Enter choice:\n1.Student Login\n2.TA Login\n3.SignUp\n
4.Searching the database\n5.Exit”);
int in 1=in.nextInt();
if(in 1==1)
{
Studentlogin(dbName);
Menu1(dbName);
}
else if(in 1==2)
{
talogin(dbName);
Menu1(dbName);
}
else if(in 1==3)
{
Signin(dbName);
Menu1(dbName);
}
else if(in 1==4)
{
search(dbName);
Menu1(dbName);
}
else if(in 1==5)
 {
System.out.println(“Existing………..!”);
System.exit(1);
}
else
{
System.out.println(“Wrong choice!!”);
Menu1(dbName);
}
}
Catch(IOException e)
{

System.out.println(“Error!”);
System.err.println(e);
e.printStackTrace();
}
}
public static void main(String[]args)throws IOException
{
Try
{
String dbName=”stu”;
CheckdbName=”stu”;
Checktables(dbName);
while(true)
{
Menu1(dbName);
}
}
catch(Exception e)
{
System.out.println(“Error in main”);
System.out.println(e);
e.printStackTrace();
}
}
}
TESTING AND DEBUGGING
10.1Introduction:
Once source code has been generated ,software must be tested to uncover(and correct)as many
errors as possible before delivery to customer .Our goal is to design a series of test cases that have a
high likelihood of finding errors.To uncover the errors of software techniques are used .These
techniques provide systematic guidance for designing test that exercise the internal logic of software
components,and exercise input and output domains of the program to uncover errors in program
function,behaviour and performance.
Internal program logic is exercised using-White box test case design Techniques.

Software requirements are exercised using – Black box test case design Techniques.

In both cases,the intent is to find the maximum number of errors with the minimum amount of effort
and time.
10.2Testing Methodologies:
A strategy for software testing must accommodate low-level tests are necessary to verify that a small
source code segment has been correctly implemented as well as high level tests that validate major
system functions against customer requirements. A strategy must provide guidance for the
practitioner and a set of mile stones for the manager. Because the steps of the tests strategy occur at
a time when deadline pressure begins to rise, progress must be measurable and problems must
surface as early as possible. Following testing techniques are well known and the same strategy is
adopted during this project testing.
10.3Unit Testing:
Unit testing focuses verification report on the smallest unit of software design-the software
component or module. The unit test is white-box oriented. The unit testing implemented in every
module of Student Record Management System by giving correct manual input to the system, the data
are stored in database and retrieved. If you want required module to access inputs or gets the output
from the End user. Any error will accured the time will provide handler to what type of will accured.
10.4System Testing:
System testing is actually a series of different tests whose primary purpose is to fully exercise the
computer-based system. Below we have describe the two types of testing which have described the
two types of testing which have been taken for this project. It is to check all modules worked on output
basis, if you want change any values or inputs will change all information, so specified input is must.
10.5Performance Testing:
Performance testing is designed to test the run-time performance of software within the context of
an integrated system. Performance testing occurs throughout all steps in the testing process. Even at
the unit level, the performance of an individual module may be accessed as white-box tests are
conducted. This project reduce student record table, codes. It will generate report first. No have extra
time or waiting of results. Entered correct data will show result few millisecond. Just used only
lowmemory of our system. Automatically do not getting access at another software. Get user
permission and access to other applications.

11.SYSTEM MAINTENANCE
Software maintenance is for more than finding mistakes. Provision must be made for environment
changes which may affects either the computer, or other parts of the computer based systems. Such
activity is normally called maintenance.
It includes both the improvement of the system functions and the corrections of faults which
rise during the operation of new system.
It may involve the continuing involvement of a large proportion of computer department resources.
The main task may be to adopt existing system in changing environment.
Backup for the entire database files are taken and stored in storage device like flash drives, pen drives
and disks so that it is possible to restore the system at the earliest. If there is breakdown or college,
then the system gives provision to restore database files.
Storing data in a separate secondary device leads to an effective and efficient maintains of the
systems. The nominated person has sufficient knowledge of the organisation’s computer past
proposed change.

12.FUTURE ENHANCEMENT

The project has a very vast scope in future. The project can be implemented in other colleges
with extra technologies and also in future. It can also be implanted in other institution too. Project
can be updated in near future as and when requirement for the same arises, as it is very flexible in
terms of expansion. With the proposed software of database Space Manager ready and fully
functional the client is now able to manage and hence run the entire work in a much better, accurate
and error free manner.
The following are the future scope of the project:
Discontinue of particular student element potential records.

Record Management System can be accessed through mobile devices.

Individual report system using login for only student and administrator and rest others can view the
details.

13.CONCLUSION
The Student Record Management System is developed using java/MYSQL/JDBC fully needs the
objectives of the system which it has been developed. The system has reached a steady state where
all bugs have been eliminated. The system is operated at a high level of efficiency and all the teachers
and user associated with the system understands its advantage. The system solves the problems. It
was intended to solve as requirement specification.

14.Bibliography
Java- The Complete Reference- Herbert Schildt
Effective java- Joshua Bloch
An Introduction to Database System- Bipin Desai
Database Management System- Johannes Gehrke
Expert Oracle JDBC Programming- R.M. MENON