Project Report Last

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 27

SAVITRIBAI PHULE PUNE UNIVERSITY

PROJECT REPORT ON

Library Management
System
SUBMMITTED TO

SKYLARK FOUNDATION’S COLLAGE OF ART,COMMERCE& SCIENCE


KHED SHIVAPUR,HAVELI,PUNE-05

AFFILIATED TO
SAVITRIBAI PHULE PUNE UNIVERSITY
B.B.A(COMPUTER APPLICATION)

UNDER THE GUIDANCE OF


PROF. DIPALI SHILVANT

FOR ACADMIC YEAR 2024-2025


SUBMITTED BY

Sneha Suil Yadav


Sejal Prakash jagade
College Management System
A PROJECT REPORT
Submitted by : Roll No

1) Sneha Yadav
2) Sejal Jagade

In partial fulfillment
of

Third Year Bachelor

IN

COMPUTER APLICATION

SKYLARK FOUNDATION’S

University Of Pune
Contents
 ABSTRACT

1. INTRODUCTION

1.1 Problem definition

2. SPECIFIC REQUIRMENTS

2.1 Hardware Interface

2.2 Software Interface

3. SOFTWARE USED

3.1 MySQL

3.2 Netbeans
4. TABLE FORMAT

5. OUTPUT SCREEN (GUI)

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

1.1 Problem Definition

Need for system:


1.2

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.

2.1 Hardware Requirements


 Windows 10 & Windows 7 OperatingSystem.

 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.

Major features as available in MySQL 8.0:

 A broad subset of ANSI SQL 99, as well as extensions


 Cross-platform support
 Stored procedures, using a procedural language that closely adheres to SQL/PSM
 Triggers
 Cursors
 Updatable views
 Online Data Definition Language (DDL) when using the InnoDB Storage Engine.
 Information schema
 Performance Schema that collects and aggregates statistics about server execution
and query performance for monitoring purposes.
 A set of SQL Mode options to control runtime behavior, including a strict mode to
better adhere to SQL standards.
 X/Open XA distributed transaction processing (DTP) support; two phase commit as part of
this, using the default InnoDB storage engine
 Transactions with savepoints when using the default InnoDB Storage Engine. The
NDB Cluster Storage Engine also supports transactions.
 ACID compliance when using InnoDB and NDB Cluster Storage Engines.
 SSL support
 Query caching
 Sub-SELECTs (i.e. nested SELECTs)
 Built-in replication support
 Asynchronous replication: master-slave from one master to many slaves or many
masters to one slave
 Semi synchronous replication: Master to slave replication where the master waits
on replication.
 Synchronous replication: Multi-master replication is provided in MySQL Cluster.
 Virtual Synchronous: Self managed groups of MySQL servers with multi master
support can be done using: Galera Cluster or the built in Group Replication plugin.
 Full-text indexing and searching
 Embedded database library
 Unicode support
 Partitioned tables with pruning of partitions in optimizer
 Shared-nothing clustering through MySQL Cluster
 Multiple storage engines, allowing one to choose the one that is most effective for
each table in the application.
 Native storage engines InnoDB, MyISAM, Merge, Memory (heap), Federated,
Archive, CSV, Blackhole, NDB Cluster.
 Commit grouping, gathering multiple transactions from multiple connections together
to increase the number of commits per second.
 The developers release minor updates of the MySQL Server approximately every two
months. The sources can be obtained from MySQL's website or from MySQL's GitHub
repository, both under the GPL license.
2.4 NetBeans
NetBeans is an integrated development environment (IDE) for Java. NetBeans allows
applications to be developed from a set of modular software components called modules.
NetBeans runs on Windows, macOS, Linux and Solaris. In addition to Java development, it
has extensions for other languages like PHP, C, C++, HTML5,[4] and JavaScript.
Applications based on NetBeans, including the NetBeans IDE, can be extended by third
party developers.
The NetBeans Platform is a framework for simplifying the development of Java
Swing desktop applications.
The NetBeans IDE bundle for Java SE contains what is needed to start developing
NetBeans plugins and
NetBeans Platform based applications; no additional SDK is required.
Applications can install modules dynamically. Any application can include the Update
Center module to allow users of the application to download digitally signed upgrades and
new features directly into the running application. Reinstalling an upgrade or a new release
does not force users to download the entire application again.
The platform offers reusable services common to desktop applications, allowing
developers to focus on the logic specific to their application. Among the features of the
platform are:
 User interface management (e.g. menus and toolbars)
 User settings management
 Storage management (carries out efficient storage)
 Window management
 Wizard framework (supports step-by-step dialogs)
 NetBeans Visual Library
 Integrated development tools
 ER Diagram
3. OUTPUT SCREEN (GUI)
3.1 – Login page to authenticate the user

3.2 – Dashboard of user having different option to navigate through program.


3.3 –
3.4 –
.
4. CONCLUSION

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.

Hence project helps in administration and management of college by aiding in


functionalities like result display and noticeboard.
5. REFERENCES
 Online References

1. www.oracle.com

2. www.stackoverflow.com

3. Java SE Technical documentation

 Books Reference

1. Core JAVA by- Cay S. Hortsmann

2. Using SQLite by- Jay Kreibich,

3. SQL Server – Black Book by- Dalton Patrik

4. Managing and Using MySQL by- Reese G., Yarger R.

5. Java Swing by- By Brian Cole, Robert Eckstein..

You might also like