1
STUDENT
INFORMATION
SYSTEM
2
TABLE OF CONTENTS
Abstract 4 Customer Specifications 4 Technical specifications 5 • Hardware specifications 5 • Software specifications 5 Project Goals 6 Project Objectives 6 Process flow diagrams 7
• Login 8 • Main Process 9 • Add Process 10 • Delete Process 11 • Modify Process 12 • View Process 13
Entity Relationship Diagram 14
Database Design 16
Data Flow Diagram 18
Screen Design 21 • Login Screen 22 • Main Screen 23 • Add Screen 24 • Delete Screen 27 • Modify Screen 29 • View Screen 31
3 • Student Report 32 Validations • Global Validations 43 • Login Validations 43 • Screen Validations 44 Future Enhancements 45 Coding Standards 45 References 46
4
STUDENT INFORMATION SYSTEM
The Student information System is a software project that runs on Swing Environment in java. This application helps to store the student’s basic information in the database.
Apart from storing, it maintains the information by doing proper updation in the database. The Student Information System has the following features:
• Student’s information can be added, deleted, modified and viewed.
• For each option proper user validation is done while entering.
CUSTOMER SPECIFICATION
The Student Information System meets the following
requirements of customer:
•
User Friendly
•
Efficient record maintenance.
•
Generates report of a particular student.
•
Proper validations are done for each and every fields of
the student details.
5
Provides security- only privileged users can alter the
information stored in database.
•
Has proper structure and flow throughout the application.
The Technical specifications of the system are as follows:
HARDWARE SPECIFICATIONS: Pentium 4 or above. 256MB RAM or above. SOFTWARE SPECIFICATIONS: JDK 1.5.0 or above Windows XP or above
6
PROJECT GOALS
The goal of the project is as follows:
• To maintain the record of every student of a school in the database.
• User can add, modify, view, delete a record in the database in swing environment which is more user friendly.
• Proper privileges is given to the user. So that only privileged user can
login and alter the database
.
PROJECT OBJECTIVES:
Validation of the user
:
The user name and password which is entered by the user is validated in the java program itself.
Maintainence of integrity of the record in
database:
If the student’s record is altered in the front end parallely it is altered in the database . Thus apart from being user friendly it maintains the integrity of the database.
7
PROCESS
FLOW
8
DIAGRAMS
Main Page
9
Add Operation
10
Delete
Operation
11
ModifyLogin
12
13
15
View
all
Login
16
View All Operation
End
Page
18
ENTITY
RELATIONSHIP
DIAGRAM
20
DATABASE DESIGN
STUDENT_DETAILS TABLE
NAME
DATATYPE
CONSTRAINTS
S_ID
NUMBER(8)
PRIMARY KEY
S_NAME
VARCHAR2(20)
NOT NULL
S_ADD
VARCHAR2(50)
NOT NULL
S_FATHER
VARCHAR2(10)
NOT NULL
S_GENDER
VARCHAR2(10)
NOT NULL
S_CLASS
VARCHAR2(10)
NOT NULL
S_SECTION
VARCHAR2(10)
NOT NULL
S_CREDITS
NUMBER(7,2)
NOT NULL
21
DATAFLOW
DIAGRAM
23
24
25
LEVEL 1-USER
27
28
LOGIN SCREEN: INVALID USER NAME
29
30
ADD SCREEN : SUBMITTING EMPTY FIELDS
32
33
ADD SCREEN : CREDENTIAL VALIDATION
35
36
37
38
39
40
41
42
43
44
LOGIN VALIDATION
INPUT
OUTPUT
Username entered.
No password.
Error message: Please enter
username and password.
No Username.
Password entered
Error message: Please enter
username and password.
No Username.
No Password.
Error message: Please enter
username and password.
Wrong username and
Password.
Error message: Invalid
username and Password
Correct Username and
Login
Successful Login.
VALIDATION FOR ADDING AND MODIFYING A
RECORD
INPUT
OUTPUT
Illegal name
Error: Please enter alphabets
in name field
Illegal gender
Error: Please choose correct
option in gender field.
Illegal class
Error: Please choose correct
option in class field.
45
option in section field.
Illegal father’s name
Error: Please enter alphabets
in name field
Illegal credentials
Error: Please enter
credentials from 1.0 to 10.0
Any blank field
Error: Please check all fields
All data correct
Successfully modified or
inserted.
VALIDATION FOR ENTERING STUDENT ID IN
DELETING, MODIFYING AND VIEWING A RECORD
INPUT
OUTPUT
Illegal number
Error: No data found.
Blank field
Error: Please enter valid
number.
Correct number
Successfully deleted or
report generated or data
retrived for modification.
46
FUTURE
47
Student information system can be implemented to get
records class wise or section wise or gender wise etc.
During student’s admission process all the student’s
details can be easily entered in the database.
The attendance of the students can be maintained.
The time table for each and every class can be
maintained.
The performance of every student can be monitored
and reports can be given to parents.
CODING STANDARDS
Use proper names methods.
All variables must begin with a small alphabet and
follow Hungarian Notation. E.g. driverName,
vehicleName
Constants must be declared in capital letters.
Unnecessary import from java.lang.
Empty finally blocks.
Empty catch block.
48
For loops use variables such as counter instead of
using “x” or “i”.
REFERENCES:
1)
JAVA THE COMPLETE REFERENCE by Herbert Schildt
2)
www.google.com
3)
