Project Report Last
Project Report Last
Project Report Last
PROJECT REPORT ON
Library Management
System
SUBMMITTED TO
AFFILIATED TO
SAVITRIBAI PHULE PUNE UNIVERSITY
B.B.A(COMPUTER APPLICATION)
1) Sneha Yadav
2) Sejal Jagade
In partial fulfillment
of
IN
COMPUTER APLICATION
SKYLARK FOUNDATION’S
University Of Pune
Contents
ABSTRACT
1. INTRODUCTION
2. SPECIFIC REQUIRMENTS
3. SOFTWARE USED
3.1 MySQL
3.2 Netbeans
4. TABLE FORMAT
6. SAMPLE CODE
7. CONCLUSION
8. REFERENCES
ABSTRACT
Technology is an important part of every day’s life. Our project is aims to deliver daily
notices, and result of students to respective student and all the teachers at tip of theair
fingers.
Every participant in this program need to register himself first by creating a account.
Creating a account comprises of filling essential details about self. Both teachers and
student will create account which would be forwarded to HOD for verification and
activation of account along with activation of account Roll no. and Teacher ID would be
assigned to student and teachers respectively automatically. Each username of teacher or
student will be unique.
On dashboard of every participant different option will be available along with their
provided details.Teachers can view result of all the students by applying different filters
such as ‘year of study’ or PRN of student. Student can view their respective results only.
Only teachers can post/ delete notices from the common noticeboard which will be visible
to all the participants..
All teachers can view complete data of student. Various filters such as ‘year of study’,
‘passing year’, or ‘PRN’ are available to filter out the students. HOD can view complete
details about students and also teachers.Data of ‘graduated student’ also remains in the
same system which in future can be retrieved by year of passing(batch) or PRN number of
student. Analysis of result is available for every personal result of student.
1. INTRODUCTION
This project can be deployed in college for every day use. Result of student will be
available with teachers and students . Data will be accessible to all the people all the time
at a single place. Important notices can be posted on the common noticeboards through
which the message can be delivered to all the students at once. To keep track of every
student, teachers can use this system to view semester wise report of student at one place.
Ease in managing the the data of passed out student . Data of the passed is stored in system
with the unique PRN student.
Basically this system can be deployed in every college or similar type of program can be
used in other organizations which have admin and employee hierarcy.
2. SPECIFIC REQUIRMENTS
The system analysis contains a planning and design phases where a logical design of
system is developed and to work accordingly a plan is established. Also the requirements
of system are identified and the operating environment is identified.
1 GB RAM
Intel®core2duo processor@3.4GHz
200MB memory Space
2.2 SoftwareRequirements
MySql
Netbeans IDE oJava
MySql connector Java
jCalander library
JDK (1.8)
SOFTWARE USED
2.3 MySql
MySQl is an open-source relational database management system (RDBMS).Its name is a
combination of
"My", the name of co-founder Michael Widenius's daughter,and "SQL", the abbreviation for
Structured Query Languag
MySQL is free and open-source software under the terms of the GNU General Public License,
and is also
available under a variety of proprietary licenses. MySQL was owned and sponsored by the
Swedish company
MySQL AB, which was bought by Sun Microsystems (now Oracle Corporation).In 2010,
when Oracle
acquired Sun, Widenius forked the open-source MySQL project to create MariaDB. MySQL
is a component of the LAMP web application software stack (and others), which is an
acronym for
Linux, Apache, MySQL, Perl/PHP/Python. MySQL is used by many database-driven web
applications,
including Drupal, Joomla, phpBB, and WordPress. MySQL is also used by many popular
websites, including
Facebook,Flickr,MediaWiki, Twitter,and YouTube.
MySQL is written in C and C++. Its SQL parser is written in yacc, but it uses a home- brewed
lexical
analyzer.MySQL works on many system platforms, including AIX, BSDi, FreeBSD, HP- UX,
eComStation,
i5/OS, IRIX, Linux, macOS, Microsoft Windows, NetBSD, Novell NetWare, OpenBSD,
OpenSolaris, OS/2
Warp, QNX, Oracle Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare, Sanos and
Tru64. A port of
MySQL to OpenVMS also exists.
The MySQL server software itself and the client libraries use dual-licensing distribution. They
are offered under GPL version 2,or a proprietary license.
Support can be obtained from the official manual.Free support additionally is available in
different IRC channels and forums. Oracle offers paid support via its MySQL Enterprise
products. They differ in the scope of services and in price. Additionally, a number of third
party organisations exist to provide support and services, including MariaDB and Percona.
MySQL has received positive reviews, and reviewers noticed it "performs extremely well
in the average case" and that the "developer interfaces are there, and the documentation
(not to mention feedback in the real world via Web sites and the like) is very, very good".It
has also been tested to be a "fast, stable and true multi-user, multi-threaded sql database
server".
MySql Features
MySQL is offered under two different editions: the open source MySQL Community
Server and the proprietary Enterprise Server.MySQL Enterprise Server is differentiated by
a series of proprietary extensions which install as server plugins, but otherwise shares the
version numbering system and is built from the same code base.
Technology is an important part of every day’s life. Our project is aims to deliver daily
notices, and result of students to respective student and all the teachers at tip of their
fingers.
Every participant in this program need to register himself first by creating a account.
Creating a account comprises of filling essential details about self. Both teachers and
student will create account which would be forwarded to HOD for verification and
activation of account along with activation of account Roll no. and Teacher ID would be
assigned to student and teachers respectively automatically. Each username of teacher or
student will be unique. On dashboard of every participant different option will be available
along with their provided details.
Teachers can view result of all the students by applying different filters such as ‘year of
study’ or PRN of student. Student can view their respective results only. Only teachers can
post/ delete notices from the common noticeboard which will be visible to all the
participants.All teachers can view complete data of student. Various filters such as ‘year of
study’, ‘passing year’, or ‘PRN’ are available to filter out the students. HOD can view
complete details about students and also teachers. Data of ‘graduated student’ also remains
in the same system which in future can be retrieved by year of passing(batch) or PRN
number of student. Data analysis of each student can be obtained for each semester.
1. www.oracle.com
2. www.stackoverflow.com
Books Reference