A

PROJECT REPORT
ON

Interactive Restaurant Website

SUBMITTED BY

Krutika Rohidas Sawale and Karishma Kailas Dalimbe

Seat number
Under The Guidance Of-
Mrs. Deepali Shilvant ma’am
BCA-SEMISTER VI

BHARAT SHIKSHAN PRASARAK MANDAL

JAIKRANTI COLLEGE OF COMPUTER SCIENCE AND MANAGEMENT STUDIES

(B.C.A. DEPARTMENT)
KATRAJ
PUNE-411 046
UNIVERSITY OF PUNE
2019-2020

Savitribai Phule University of Pune

JAIKRANTI COLLEGE OF COMPUTER SCIENCE

AND MANAGEMENT STUDIES, KATRAJ, PUNE-46
 This is to certify that Sejal jagade and Sneha Yadav students of

TYBBA(CA) have satisfactorily completed their project work entitled “College

Management System” And submitted the project for the fulfilment of Bachelor
of Business Administration (Computer Applications) as per the syllabus of Savitribai
Phule University of Pune, during the academic year 2023-24

Date:
Place:

Project Guide HOD Principal

Internal Examiner External Examiner

 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:

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