STUDENT
MANAGEMENT
SYSTEM
Project Report
Under the supervision of
DR. NEENA GUPTA
ASSISTANT PROFFESOR
Department. of Computer Science
KGC, Dehradun
DEPARTMENT OF COMPUTER SCIENCE
KANYA GURUKUL CAMPUS,DEHRADUN
Second Campus of Gurukula Kangri Vishwavidyalaya
Haridwar, Uttarakhand (India)
MAY,2020
CANDIDATE’S DECLARATION
I hereby declare that the presented in the report entitled ‘STUDENT
MANAGEMENT SYSTEM’ in java for the fulfilment of requirement
for the award of the degree of MASTER OF COMPURT
APPLICATION, submitted the department of Computer Science, Kanya
Gurukul Campus Dehradun(Second campus of Gurukul Kangri
Vishwavidyalaya, Haridwar), is an authentic record of my work carried
out under the guidance of Dr. Savita(Assistant Professor) Department of
Computer Science ,Kanya Gurukul Campus Dehradun.
The matter embodied in this report has not been submitted by me for the
award of any other degree/examination.
(KANIKA DHIMAN)
MCA 4TH Semester
KGC, Dehradun
This is to certify that the above statement made by the candidate is
correct to the best of my knowledge.
Dr. Savita
Dept. Of Computer Science,
Kanya Gurukul campus, Dehradun(India).
Acknowledgement
I would like to express my profound gratitude and thanks to respected
Dr. Neena Gupta for her immense support, valuable guidance and
advices during the preparation of this seminar. She helped nurse this
project from idea of stage to the record. I tried my maximum to make
this seminar according to her suggestion and direction.
I am also thankful to Dr. Nipur and Dr. Praveena Chaturvedi who never
hesitated to extend her helping hand whenever required during the
seminar. I also extend my sincere thanks to Dr. Heman Pathak, for
support and also making available the computer resources.
Date: Kanika Dhiman
MCA 4th sem
ABTRACT
The project titled “STUDENT MANAGEMENT SYSTEM” is database
management software for monitoring and controlling the system in
colleges. The project “Student Management System” is developed in
Java, which mainly focuses on basic operation like adding new student’s
data, and updating new information, assigning the staff. It features a
familiar and well thought-out, an attractive user interface, combined
with strong searching insertion and reporting capabilities. The backend
of the project is designed using MS-access.
Contents
1. INTRODUCTION............................................................................6
1.1. Purpose:.......................................................................................6
1.2. Objective:....................................................................................6
1.3. Advantages:.................................................................................6
1.4. Limitations:.................................................................................7
1.5. Software requirement:.................................................................7
1.6. Hardware requirement:...............................................................8
2. System design...................................................................................8
2.1. Modules........................................................................................8
2.1.1. User module.........................................................................8
2.1.2. Student module....................................................................9
2.1.3. Mark management..............................................................9
2.2. Data Flow Diagram.....................................................................9
2.2.1 Context Diagram:.................................................................9
2.2.2. Level 1................................................................................10
2.3. E-R Diagram.............................................................................11
2.4. Database Design.......................................................................12
2.4.1. Student................................................................................12
2.4.2. UAD....................................................................................13
2.4.3. Subjects...............................................................................13
2.4.4. Subject Allocation...............................................................14
2.4.5. SSLC1.................................................................................14
2.4.6. PLUSTWO1......................................................................14
3. Software Implementation:...............................................................15
3.1. Coding.........................................................................................16
3.2. Snapshot of O/P..........................................................................19
4. Conclusion......................................................................................28
5. Bibliography...................................................................................28
1. INTRODUCTION
Student Management System is software which is helpful for students as well as
the school authorities. In the current system all the activities are done manually. It
is very time consuming and costly. Our Student Management System deals with
the various activities related to the students.
1.1. Purpose:
A student management system helps a school manage data,
communication, and scheduling. A system generates and uses a large
amount of data. This data must be communicated appropriately to
student, faculty, and parents. A student management system helps to
store, manage and distribute this information.
1.2. Objective:
The objective of SMS is to get an understanding of how the business
works. The college presuppose having an incredible SMS for keeping
their information secure and make their organization less complex. The
organization system can give basic way where the administrator can
control data and information about researchers and staff smoothly.
This SMS will be built based on identification some key qualities
document and their relations. With the understanding of the structure
and content of key quality documents, it will help to reduce the
duplication and save more time.
1.3. Advantages:
It helps to manage student data.
It will reduce your time.
You don’t need to take attendance on paper.
SMS has individual portal like admin portal, student portal.
System will generates reports
SMS allow registering or deregistering.
1.4. Limitations:
High security is needed to protect especially in case of universities.
Financial details not to mention the other contact details of
students.
Personal information protection is a serious responsibility and
heavily punishable by the law.
The storage capacity needed for the amount of students. The more
students, the more data, and the more data means more memory is
required.
1.5. Software requirement:
A set of programs associated with the operation of a computer is
called software. Software is the part of the computer system, which
enables the user to interact with several physical hardware devices.
The minimum software requirement specifications for developing
this project are as follows:
Operating System : Windows NT/ 98/ XP/7/8/10.
Language : Java 2 Runtime Environment
Database : MS Access2007.
1.6. Hardware requirement:
The collection of internal electronic circuits and external physical
devices used in building a computer is called the Hardware. The
minimum hardware requirement specifications for developing this
project are as follows:
Processor : Pentium III 630MHz
RAM : 128 MB
Hard Disk : 20GB
Monitor : 15” Color monitor
Key Board : 122 Keys
2. System design
2.1. Modules:
There are mainly 3 modules in this software
2.1.1. User module:
In the Software we can register as a user and user has of two types,
student and administrator. Administrator has the power to add new user
and can edit and delete a user.
2.1.2. Student Module:
A student can register as user and can add edit and delete his profile.
2.1.3. Mark management
The administrator can add edit and delete marks for the student. All the
users can see the marks.
2.2. Data Flow Diagram:
2.2.1 Context Diagram:
Student administrator marks entry
Student info entry marks entry
Student
administrator management
User account maintainence system
student info reports generated
Mark-sheets generated
2.2.2. Level 1:
Add new student
Edit student data
Remove student Student
Update student
Search student
2.3. E-R Diagram:
2.4. Database Tables:
The general theme behind a database is to handle information as an integrated
whole. A database is a collection of interrelated data stored with minimum
redundancy to serve many users quickly and effectively. After designing input
and output, the analyst must concentrate on database design or how data should
be organized around user requirements. The general objective is to make
information access, easy quick, inexpensive and flexible for other users. During
database design the following objectives are concerned:-
Controlled Redundancy
Data independence
Accurate and integrating
More information at low cost
Recovery from failure
Privacy and security
Performance
Ease of learning and use
TABLES USED
2.4.1. Student
Field Name Data Type Description
RollNo Number Primary Key
SName Text(50) -
Phno Text(15) -
Sex Text(10) -
FName Text(50) -
Occupation Text(50) -
MName Text(50) -
DOB Date/Time -
Age Number -
Caste Text(25) -
Religion Text(30) -
Hname Text(50) -
City Text(50) -
District Text(50) -
State Text(50) -
Pin Text(10) -
Year Number -
Qualification Text(25) -
2.4.2. UAD
Field Name Data Type Description
Username Text(25) Primary Key
Password Text(15) -
Type Text(15) -
2.4.3. Subjects
Field Name Data Type Description
Subjectcode Text(10) Primary Key
Subjectname Text(50) -
Creditmark Number -
MaxMark Number -
Type Text(25) -
2.4.4. Subject Allocation
Field Name Data Type Description
Subjectname Text(50) -
Semester Number -
Batch Text(15) -
2.4.5. SSLC1
Field Name Data Type Description
RollNo Number -
SubjectName Text(50) -
Subjectcode Text(15) -
Internal Number -
Theory Number -
Practical Number -
Total Number -
2.4.6. PLUSTWO1
Field Name Data Type Description
RollNo Number -
SubjectName Text(50) -
Subjectcode Text(15) -
Internal Number -
Theory Number -
Practical Number -
Total Number -
3. Software Implementation:
3.1. Coding:
Login:
import java.awt.Container;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
public class Login extends JFrame implements ActionListener {
Container c = getContentPane();
private JButton btnLogin, btnCancel;
private JLabel lblUName, lblPasswd;
private JTextField txtUName;
private JPasswordField txtPasswd;
public Login() {
super("Login ...");
this.setSize(350, 200);
this.setLayout(null);
this.setResizable(false);
this.setLocation((Settings.getScreenSize().width / 2) - 175,
(Settings.getScreenSize().height / 2) - 150);
this.setDefaultCloseOperation(EXIT_ON_CLOSE);
lblUName = new JLabel("Username");
lblPasswd = new JLabel("Password");
txtUName = new JTextField();
txtPasswd = new JPasswordField();
btnLogin = new JButton("Login", new
ImageIcon(ClassLoader.getSystemResource("Images/login.png")));
btnCancel = new JButton("Cancel",new
ImageIcon(ClassLoader.getSystemResource("Images/cancel.png")));
lblUName.setBounds(50, 40, 140, 25);
txtUName.setBounds(150, 40, 130, 25);
lblPasswd.setBounds(50, 80, 140, 25);
txtPasswd.setBounds(150, 80, 130, 25);
btnLogin.setBounds(50, 120, 100, 25);
btnCancel.setBounds(180, 120, 100, 25);
btnLogin.addActionListener(this);
btnCancel.addActionListener(this);
this.add(lblUName);
this.add(lblPasswd);
this.add(txtUName);
this.add(txtPasswd);
this.add(btnLogin);
this.add(btnCancel);
}//constructor closed
public void actionPerformed(ActionEvent e) {
if (e.getSource() == btnLogin) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con =
DriverManager.getConnection("jdbc:odbc:student");
try {
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM UAD
WHERE Username='" + txtUName.getText() +
"' and Password='" + txtPasswd.getText() + "'");
if (rs.next()) {
if (rs.getString(3).equals("Student")) {
userMDI frm = new userMDI();
frm.setVisible(true);
} else {
new frmAdminMDI().setVisible(true);
}
this.dispose();
}else{
JOptionPane.showMessageDialog(null,"Invalid username or
password","Invalid",JOptionPane.ERROR_MESSAGE);
}
con.close();
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "Invalid username or
password", "Invalid", JOptionPane.ERROR_MESSAGE);
txtUName.setText("");
txtPasswd.setText("");
}//inner try catch closed
} catch (Exception x) {
JOptionPane.showMessageDialog(null, "Unable to connect to the
database", "Connection error", JOptionPane.ERROR_MESSAGE);
}//outer try catch closed
}//if closed
if (e.getSource() == btnCancel) {
System.exit(0);
}//if closed
}//actionPerformed() closed
public static void main(String args[]) {
new Login().setVisible(true);
}
}//class closed
3.2. Snapshot Of O/P:
Login
Add new user
Edit User Type
Delete User
Student Registration
Edit Student Details
Delete Student details
Add/Edit Mark Details
View Marks
View User details
View Student Details
Add New Subjects
Edit Subject details
Delete Subject details
Subject Allocation
4. Conclusion
Our project is only a humble venture to satisfy the needs in an Institution.
Several user friendly coding have also adopted. This package shall prove to be
a powerful package in satisfying all the requirements of the organization.
The objective of software planning is to provide a frame work that enables the
manger to make reasonable estimates made within a limited time frame at the
beginning of the software project
5. Bibliography
1) http://www.javaworld.com/javaworld/jw-01-1998/jw-01-
bookreview.html
2) Database Programming with JDBC and Java by O'Reilly
3) Head First Java 2nd Edition
4) http://www.jdbc-tutorial.com/
5) Java and Software Design Concepts by A Press
