JAGRAN INSTITUTE OF MANAGEMENT

SYNOPSIS
ON
Time Table Generator
System

Submitted to – Submitted by -
Mr. Ashish Mishra Sanchit Gupta
Assistant Professor MCA – 4th Semester
AKTU Roll No - 1904340140006
 INTRODUCTION

Time Table Generator System

Time table scheduling has been in human need ever since they thought about managing time
efficiently. It is widely used in schools, colleges and other areas of teaching and serves as a crash
course. In the early days, scheduling was incorporated into the work of scheduling by an individual
or group. And time. It can also take a long time when determining small limits and increasing the
amount of data to deal with the number or increments of the range. Completely re-designed time
tables can be reused for the entire generation with no changes, in such cases they will be slowed
down. Other cases occur because the problem is a change in the number of faculty or students,
which can immediately change the timetable. Although most of the college work is computerized,
the timetable is largely determined manually. Manual lecture scheduling requires considerable
time and effort.

Lecture-scheduling is a limiting satisfaction problem in which we find a solution that satisfies the
given constraints. Automatic Timetable Generator is a Java-based software that is used to
generate periodically and automatically. The difficulties posed by the time table can be
represented as a constraint satisfaction problem with loose parameters and multiple constraints.
These constraints can be replicated in a format that can be organized in a systematic manner
through a scheduling algorithm. Scheduling involves the use of multiple path restrictions, which
can be used to complete tasks. For example, when scheduling classes at an institution, a single
time slot is not assigned to a single faculty member who teaches two courses. On the other hand,
two different courses should not be distinguished for participation by the same group of students.
 OBJECTIVE

Normally timetable generation done manually. As we know all institutions/organizations have

it’s own timetable, managing and maintaining these will not be difficult. Considering workload
with this scheduling will make it more complex. As mentioned, when Timetable generation is
being done, it should consider the maximum and minimum workload that is in a college. In
those cases timetable generation will become more complex.
Hence, the main objective of this project is to generate the timetable automatically without
any manual workload and saves a lot of time that plays a prominent role in the present lifestyle
It will also manage timetable when any teacher is absent late coming or early going. Proposed
system will help to generate it automatically also helps save the time.
 PROJECT CATEGORY

Time Table Generator System is built using technologies like Java Swings and AWT, for the
frontend and JAVA, MYSQL for the backend. Hence it comes under the category of a Window-
based application software.
A Window application is a computer program that uses a window platform to perform a
particular function. It is also called a window app. Window apps are present on many
applications.
A window application is a client-server program. It means that it has a client-side and a server-
side. The term "client" here refers to the program the individual uses to run the application. It is
part of the client-server environment, where many computers share information. For example,
in the case of a database, the client is the program through which the user enters data. The
server is the application that stores the information.

Windows Programming with Java is the utilization of the CPU, its registers, and other hardware
and software devices to use and execute the task. In Java, it has libraries that support the
Windows OS.

It is also part of Java Foundation Classes and is used for the development of Window based
applications that are built on top of AWT plus written in the Java programming language. It is a
lightweight Java GUI toolkit with a strong set of widgets. When a beginner begins to learn Java,
the concept of the Swing is one of the requirements.
DATA FLOW DIAGRAM
 MODULES

Register – This module allows a new admin to enter his/her details like – name, e-mail,
password etc into a form and after submitting it, admin becomes a registered admin and can log
in into the software.

Login – This module takes the user email-id and password into a form then checks in database
whether the user is a valid user or not. If yes it will redirect the user to the homepage. If no then
the appropriate error message will be on the screen.

Time Table Generation Module – In this module, generation is done by considering the
maximum and minimum workload for each faculty. This will be generated by the admin and
viewed by the faculty who are the users of this system.
 SYSTEM REQUIREMENTS
Hardware Requirement
 Intel Pentium processor or higher.
 512 MB RAM.
 10 GB Free Hard Disk Space.
 Speed 2 GHZ

Software Requirement
 Windows XP/7/vista or above.
 MySQL Server.
 JDK and JRE 8.0.
 DATA STRUCTURES OF TABLE
 Admin table

 Faculty table

 Course table
Semester table

 Labs table

 Subjects table
 SECURITY MECHANISM

Security is a standout amongst the most vital factors as ordered information will be contained in a
database. Client approval will be contained ina database. Client approval will be performed admin
login to ensure that client is legitimate and his or her entrance is restricted to their particular
concent information.
SQL Injection
SQL Injection is a very common form of attack accounting for about two-thirds of all windwos
attacks. With improper or ineffective code leading to a SQL Injection attack, a data breach can
occur resulting in the leakage of important details.
Below is an example of an insecure code snippet:
$psswd = $_POST[“password”];
$sql=”SELECT * FROM users WHERE password=’$psswd’”;

Now, an attacker can send in a query that will be executed along with the query. To avoid that
you can use functions such as mysql_escape_string()

Password storage

With the increasing cases of credential theft and data dumping on the dark web, storing
credentials such as passwords securely has become much more important. In case there is a
breach of security, it is important to ensure that attackers are unable to decode the passwords
and cause further damage.

There are two important ways to securely store passwords, using a hashing algorithm like MD5.
In Java we have the function PasswordManager() which take a string as password and returns
its Becrypted password, which we can store in database.
 FUTURE SCOPE

The Automatic Timetable Generator is driven portal for educational organization and is a
window based application which will be helpful for creating Time table. This project will be a
great helpful for the institutions because, It is a great difficult task that to manage many
Faculty's and allocating subjects for them at a time manually and this project will help to
manage it properly. This manage timetable for faculty with considering maximum and
minimum workload, and can be managed easily.
Our goal is to solve the college lecture fixing problem with our policy. We also hope to show
you how to fit our timetable system into a rich desktop application. The user interface
(Windows Forms Application) used in this application provides an easy way to understand how
the application works and also provides input accessibility. The faculty and subject information
is stored in MySQL (database) and then using the available data it generates a lecture-course
timetable with minimal time. The timetable production system makes a timetable for each
class and teacher according to availability. Is. Capacity of physical resources, such as
classrooms, laboratories, and computer rooms) and rules applicable to different classes,
semesters, teachers, and subject levels. The great thing is that this timetable generation
greatly improves the use and optimization of system resources.