student
Content
Under the esteemed guidance of:
Mr. N. Rama Rao
By:
P. Seshu(07M61A0544) Ch. Umamaheswar Rao(07M61A0556) P. V. Kanth(07M61A0560) M. Veda Kumar Raja(07M61A0561)
Associate Professor, Dept. of CSE.
1
Every educational institution needs to maintain the records of each and every student. maintain personal and academic information of the students. Manual or stand alone application- The old day approach lack of consistency and redundancy in the data records
(Contd..)
2
Automation of the processes in web environment- The New day approach Student Administration System Enables to
Capture Maintain Update & Provide
personal and academic information of present and past students of any educational organization
3
implementation of campus processes to ensure the integrity, security, and privacy of student data while at the same time enhancing the quality of service to the campus community. Providing Web-based environment
(Contd..)
4
3 key points to note: the system will be owned by the functional users of the data existing processes will not simply be replaced, the aim is to re-engineer more efficient and effective processes data will be captured as close to source as possible with a standard suite of management
5
This application program is strictly an application only for educational institutions.
6
Editing of even personal fields can·t be done by students.
7
x Confidential and authenticated access to data x GUI x Easy database maintenance x Simplicity x Building and maintenance cost must be less.
8
Operating System:
Microsoft Windows Xp/Linux
Environment:
Apache Tomcat 5.0 HTML, DHTML, JSP, Servlets
Database:
MySQL 5.0
9
logindemo login()
login userid password sumbit validate() logininfo() opname()
logininfo dbconnection()
subjects subid subname new() save() delete() cancel()
dbconnection name
jtabbedpanedemo size color
branch bid bname new() save() delete() cancel()
exams examid examname new() save() delete() cancel()
studentinfo subid subname semester semid semname new() save() delete() cancel() branchsubjects new() save() cancel() delete() new() save() delete() cancel()
10
login username : string psswd : string login()
dbconnection conn : conection establish() terminate()
login info user name : string passwd : string getusername() getpasswd() validate()
next page height : num width : num getnewpage() makegui()
11
12
13
fid dname department did courses Works in teach has iname icode iaddr student faculty
fname
institution sid sname
Studies in
14
saddr
GUI
Username & password
Validation
GUI(yes) Validation Authentication On validation GUI(no)
15
Add exams
Add branch es Add subjec ts
admin
Authenti cated login
GUI showing all operations Assign works
Add permiss ions
Modify data
16
view exams
client
Authenti cated login
View subjec ts GUI showing all operations do works
View details
17
18
19
Field Course_name Branch_name Branch_code Available_seats Category
Type Char(15) Char(15) Int(11) Int(11) Char(15)
Constraints
20
Field Userid Firstname Lastname password
Type Varchar(30) Varchar(30) Varchar(50) Varchar(10)
Constraints Primary key
Field Subid subname
Type Varchar(30) Varchar(30)
Constraints
21
Field Examid Examname
Type Char(20) Char(30)
Constraints
Field Semester Name Semid
Type Char(20) Char(30) Char(20)
Constraints
22
Field Batchid Admissionno Semid Branchname Sectionid Firstname Lastname Gender Admissiondate Dob Classadmitted
Type Char(20) Char(30) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Date Date Char(20)
Constraints
Primary key
contd
23
Field Idmark1 Idmark2 Parentnaem Street State Country Pincode Religion Caste Subcaste Emailid
Type Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20)
Contraints
contd
24
Field Mobileno Landline Studenttype Mothertongue Campusid Catagorycode Region Halltickno Ranksecured branchalloted
Type Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20)
Contraints
Qualifyingexamname Char(20)
25
Student Enrollment System Student Administration System Academic Management System
&
Client Admin
26
Student Enrollment System
student scheduling and enrollment management software provides a simple setup of programs, courses, terms, and even nonterms for student enrollment. helps each student design a path through your programs and courses.
27
Student Administration System
empowers you to generate interest in your programs, connect with prospective students, and make it easy for prospects to apply and enroll at your institution Provides enriched information about student admissions.
28
Academic management software
provides all the tools to track students as they progress towards program completion and graduation. Allows faculty to keep track of student progress through the academics.
29
Client
Client is allowed to register into the application Client is given access for viewing the information of his own account Editing of data cannot be done by client
30
Admin
Admin is the whole of the system He is the center of activities in the system He is the one who can edit the databases Admin is allowed to modify, delete and update records where client is allowed only for viewing
31
Applying advanced cryptography and network security Any other requirements of users will be added to the existing system
32
Books:
Software Engineering
(Roger Pressman
Database Management Systems
(Geherke and Rama Krishna
The Complete Reference Java
(Herbert Schildt
Web:
www.google.com www.blackle.com www.programmersheaven.com http://www.unimelb.edu.au/student/
33
34
35
Mr. N. Rama Rao
By:
P. Seshu(07M61A0544) Ch. Umamaheswar Rao(07M61A0556) P. V. Kanth(07M61A0560) M. Veda Kumar Raja(07M61A0561)
Associate Professor, Dept. of CSE.
1
Every educational institution needs to maintain the records of each and every student. maintain personal and academic information of the students. Manual or stand alone application- The old day approach lack of consistency and redundancy in the data records
(Contd..)
2
Automation of the processes in web environment- The New day approach Student Administration System Enables to
Capture Maintain Update & Provide
personal and academic information of present and past students of any educational organization
3
implementation of campus processes to ensure the integrity, security, and privacy of student data while at the same time enhancing the quality of service to the campus community. Providing Web-based environment
(Contd..)
4
3 key points to note: the system will be owned by the functional users of the data existing processes will not simply be replaced, the aim is to re-engineer more efficient and effective processes data will be captured as close to source as possible with a standard suite of management
5
This application program is strictly an application only for educational institutions.
6
Editing of even personal fields can·t be done by students.
7
x Confidential and authenticated access to data x GUI x Easy database maintenance x Simplicity x Building and maintenance cost must be less.
8
Operating System:
Microsoft Windows Xp/Linux
Environment:
Apache Tomcat 5.0 HTML, DHTML, JSP, Servlets
Database:
MySQL 5.0
9
logindemo login()
login userid password sumbit validate() logininfo() opname()
logininfo dbconnection()
subjects subid subname new() save() delete() cancel()
dbconnection name
jtabbedpanedemo size color
branch bid bname new() save() delete() cancel()
exams examid examname new() save() delete() cancel()
studentinfo subid subname semester semid semname new() save() delete() cancel() branchsubjects new() save() cancel() delete() new() save() delete() cancel()
10
login username : string psswd : string login()
dbconnection conn : conection establish() terminate()
login info user name : string passwd : string getusername() getpasswd() validate()
next page height : num width : num getnewpage() makegui()
11
12
13
fid dname department did courses Works in teach has iname icode iaddr student faculty
fname
institution sid sname
Studies in
14
saddr
GUI
Username & password
Validation
GUI(yes) Validation Authentication On validation GUI(no)
15
Add exams
Add branch es Add subjec ts
admin
Authenti cated login
GUI showing all operations Assign works
Add permiss ions
Modify data
16
view exams
client
Authenti cated login
View subjec ts GUI showing all operations do works
View details
17
18
19
Field Course_name Branch_name Branch_code Available_seats Category
Type Char(15) Char(15) Int(11) Int(11) Char(15)
Constraints
20
Field Userid Firstname Lastname password
Type Varchar(30) Varchar(30) Varchar(50) Varchar(10)
Constraints Primary key
Field Subid subname
Type Varchar(30) Varchar(30)
Constraints
21
Field Examid Examname
Type Char(20) Char(30)
Constraints
Field Semester Name Semid
Type Char(20) Char(30) Char(20)
Constraints
22
Field Batchid Admissionno Semid Branchname Sectionid Firstname Lastname Gender Admissiondate Dob Classadmitted
Type Char(20) Char(30) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Date Date Char(20)
Constraints
Primary key
contd
23
Field Idmark1 Idmark2 Parentnaem Street State Country Pincode Religion Caste Subcaste Emailid
Type Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20)
Contraints
contd
24
Field Mobileno Landline Studenttype Mothertongue Campusid Catagorycode Region Halltickno Ranksecured branchalloted
Type Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20) Char(20)
Contraints
Qualifyingexamname Char(20)
25
Student Enrollment System Student Administration System Academic Management System
&
Client Admin
26
Student Enrollment System
student scheduling and enrollment management software provides a simple setup of programs, courses, terms, and even nonterms for student enrollment. helps each student design a path through your programs and courses.
27
Student Administration System
empowers you to generate interest in your programs, connect with prospective students, and make it easy for prospects to apply and enroll at your institution Provides enriched information about student admissions.
28
Academic management software
provides all the tools to track students as they progress towards program completion and graduation. Allows faculty to keep track of student progress through the academics.
29
Client
Client is allowed to register into the application Client is given access for viewing the information of his own account Editing of data cannot be done by client
30
Admin
Admin is the whole of the system He is the center of activities in the system He is the one who can edit the databases Admin is allowed to modify, delete and update records where client is allowed only for viewing
31
Applying advanced cryptography and network security Any other requirements of users will be added to the existing system
32
Books:
Software Engineering
(Roger Pressman
Database Management Systems
(Geherke and Rama Krishna
The Complete Reference Java
(Herbert Schildt
Web:
www.google.com www.blackle.com www.programmersheaven.com http://www.unimelb.edu.au/student/
33
34
35
