A MINI PROJECT -1

REPORTED ON
ONLINE TC APPLICATION FORM
Submitted in the partial fulfilment of the requirements for the awards
Of
BACHELOR OF TECHNOLOGY
IN
COMPUTER SCIENCE AND ENGINEERING
Submitted by
D. VARSHITHA 20568T0912
G. MAMATHA 20568T0919
A. MADHAVI 215680954L
R. MEENAKSHI 215680964L
S. ANUSHA 20568T0946

Under the guidance of

Submitted to

DEPARTMET OF COMPUTER SCIENCE AND ENGINEERING

CERTIFICATE

This is to certify that the project titled “ONLINE TC APPLICATION FORM“ has been completed
in the academic year 2020 – 2024 by D. Varshitha (20568T0912), G. Mamatha (20568T0919), A.
Madhavi (215680954L), R. Meenakshi (215680964L) and S. Anusha (20568T0946) partial
fulfilment of the Bachelor of Technology in the third year Computer Application as prescribed by
Kakatiya University College of Engineering and Technology.

HOD&INTERNAL GUIDE PRINCIPAL

We declare that this written submission represents our ideas in our own words, we have adequately
cited and referenced the original sources. We declare that the work presented in this project report is
original and carried out in the development of Computer Science and Engineering, University College
of Engineering and Technology for Women, Warangal, Telangana and have not been submitted
elsewhere for any graduate in part or in full.

D. VARSHITHA 20568T0912
G. MAMATHA 20568T0919
A. MADHAVI 215680954L
R. MEENAKSHI 215680964L
S. ANUSHA 20568T0946
 ACKNOWLEDGEMENT

The success accomplishment in this project would not have possible, by timely help and guidance
rendered by many people well wish to express our sincere heartfelt gratitude to all those who have
helped and guided us for the completion of the project. We eamestly thank PRINCIPAL Prof.
M.SADANANDAM for giving timely cooperation and taking necessary action throughout for our
project. We express our sincere thanks and gratitude to HOD Smt.K.VANISREE for her valuable
guidance through provoking discussion, suggestion and sharing her valuable expertise throughout the
project work. We would also thank all the staff of the department of CSE, who has helped us
directly/indirectly for the successful completion of the project.
 ABSTRACT

The online TC application form project is a web-based system that facilitates the submission and
processing of transfer certificate (TC) requests for students in educational institutions. The system
allows students to fill out the necessary information online and submit their TC requests
electronically. The project aims to streamline the TC request process, reduce paperwork, and improve
the overall efficiency of the TC issuing process. It also provides administrators with an easy-to-use
interface to manage the TC requests and issue TCs to students quickly. The system features secure
authentication and authorization mechanisms to ensure the confidentiality and integrity of student
data. Traditionally, students have to fill out physical forms, wait in long queues, and manually submit
their applications to the school administration to obtain their TCs. This process is often tedious, time-
consuming, and prone to errors, leading to delays in the issuance of TCs. The online TC application
form project aims to solve these issues by providing a simple, efficient, and user-friendly platform
for students to submit their TC requests online. Overall, this project provides a convenient and
efficient solution for students and administrators alike, helping`1` to simplify the process of TC
application and issuance.
 INDEX

CONTENT PAGENO

1. INTRODUCTION
1.1 Introduction 1

2.LITERATURE SURVEY 2

3.SYSTEM ANALYSIS
3.1 Existing system 3
3.2 Proposed system 4

4. MODULE DESCRIPTION 5

5. SYSTEM REQUIREMENTS 6
5.1 Software requirements
5.2 Hardware requirements

6. ALGORITHM 7

7. SYSTEM DESIGN
7.1 ER Diagram 8
7.2 Use case diagram 9
7.3 Class diagram 10

8. SOFTWARE DESCRIPTION 11
9. OUTPUT SCREENSHOTS 12-14

10. CONCLUSION 15

11. FUTURE SCOPE 16

12. REFERENCES 17
 1.INTRODUCTION

Transferring to a new school can be an exciting opportunity for students, but it can also come with its
fair share of challenges. One of these challenges is the process of obtaining a Transfer Certificate (TC)
from their current school. Traditionally, students have to physically visit the school, wait in line, and fill
out a paper-based TC application form to begin the process of transferring to a new school. However,
with the advent of technology, there is now an opportunity to streamline this process through the
development of an online TC application form. An online TC application form will provide students with
a more convenient and efficient way of applying for their TC from anywhere, at any time, using a
computer or mobile device. With an online TC application form, students will be able to submit their
application form and all necessary documentation online, eliminating the need for physical visits to the
school. The application form will be user-friendly and easy to navigate, with clear instructions and
prompts for filling out the form. Overall, an online TC application form offers several advantages over
the traditional paper-based process, including convenience, faster processing times, accurate data
collection, real-time status updates, and reduced workload for school administrators. By implementing
this technology, schools can promote a more efficient, effective, and user-friendly process for students
seeking to obtain their TCs.

1
 2.LITERATURE SURVEY

Dr. C Srinath: Head of SBTET. This app presents the development of an online tc application system for
Telangana for diploma. The system was developed using java, mysql and includes features such as online
application form, payment gate way.

S. Sridhar and S. Sundararajan - This paper presents the development of an online TC application system
for a college in India. The system was developed using ASP.NET and SQL Server and includes features
such as online application form, document upload, payment gateway integration, and tracking system.

J.D. Tamayo, J.J. Quiazon, and J.C. Viray - This paper presents the development of an online TC
application system for a university in the Philippines. The system was developed using PHP and MySQL
and includes features such as online application form, document upload, and payment gateway
integration.

2
 3.1 EXISTING SYSTEM

The existing system for applying for Transfer Certificates (TCS) typically involves visiting the
administrative office of the educational institution and filling out a physical application form. The
student must provide their personal details, academic information, and the reason for the transfer. The
institution then processes the application and issues the transfer certificate, which the student collects
from the administrative office. This traditional process can be time-consuming, inconvenient, and
prone to errors. Students may have to take time off from their classes to visit the administrative office,
and the processing of the application may take several days. Additionally, there is a risk of losing or
misplacing the physical application form or the transfer certificate, which can cause further delays
and complications. To address these issues, many educational institutions are now implementing
online application systems for TCs. These systems allow students to apply for TCs from anywhere,
at any time, using a computer or mobile device. The online application form typically includes the
same fields as the physical form, such as personal and academic information, as well as the reason
for the transfer. Students may also be required to upload supporting documents, such as a scanned
copy of their previous academic record.

DRAWBACKS
➢ Inconvenient
➢ Time consuming
➢ Loosing forms

3
 3.2 PROPOSED SYSTEM

The main goal of the proposed system is to provide a convenient and efficient way for students to
apply for a TC online, without having to physically visit the institution's office. This will save both
time and effort for the students and reduce the workload of the administrative staff. To achieve this
goal, the proposed system will be web-based and accessible from anywhere, anytime. The system
will be designed with a user-friendly interface that will guide users through the application process
step by step. The application form will be customized to include all the necessary fields required for
a TC application, including personal information, academic details, reason for leaving, and any other
relevant information. Users will also be able to upload supporting documents such as transcripts,
certificates, or identification documents.

The system will also feature a payment module that will enable users to make the payment for the
TC application through the online system. Users will be able to choose from different payment
options such as credit card, debit card, or net banking. The system will generate a receipt of the
payment and keep a record of it for future reference.

ADVANTAGES

Convenient

➤ Time saving

➤ Status checking

➤ Cost effective

4
 4.MODULES
This Project involves following modules

1. User
2. Admin

User Module:

Login Module: This module will allow users to create an account by providing their personal
information such as name, email, phone number, and password. Once the registration is complete, the
user can log in to the system to access the TC application form.

Application Form Module: This module will provide a user-friendly interface for users to fill out the
TC application form. The form will consist of different fields such as personal information, academic
details, reason for leaving, and other relevant details. Users can also upload supporting documents such
as transcripts or certificates.

Application Checking Module: This module will allow users to check the status of their application in
real-time. Users can log in to their account to view the progress of their application, whether it is
pending, approved, or rejected. Users will also receive notifications and updates through email or SMS.

Admin Module:

Dashboard Module: This module will provide an overview of all the TC applications received, their
status, and other relevant details. The admin can filter and search the applications based on different
parameters such as date, name, or status.

Application Management Module: This module will allow the admin to manage the TC applications
received. The admin can review the applications for accuracy and completeness, verify the authenticity
of the supporting documents, and approve or reject the applications based on the eligibility criteria.

Reports Module: This module will allow the admin to generate reports and analytics on the TC
application process. The admin can track the number of applications received, the approval rate, the
reasons for rejection, and other relevant details. These reports can help the admin to monitor and
evaluate the system's performance and identify areas for improvement.

5
 5.SYSTEM REQUIREMENTS

Software requirements:
➢ Operating system: Windows 11
➢ IDE: JDK 18
➢ Languages: java, html, mysql

Hardware Requirements:
➢ Microprocessor: core i5
➢ RAM: 8GB
➢ Hard disk: 256GB

6
 6.ALGORITHM
➢ User Registration: The system prompts the user to create an account by providing their personal
information, email and password.
➢ Login: The user logs into the system using their email and password.
➢ Application form: The user fills in the application form with their personal details, academic
information.
➢ Review and Confirmation: The user reviews their application details and makes any necessary
changes, then they confirm the details and submit the application.
➢ Notification: the system sends an automated notification to the user, confirming the submission of the
application.
➢ Status Checking: The user can check the status of their tc . The system updates the status of the
application at each stage of the process, from submission to approval and issuing the TC .
➢ Issuing the TC: Once the application is approved, the system generates the TC and sends it to the
user.

7
 SYSTEM DESIGNS
7.1 ER DIAGRAM

There are two entities:

User Entity: It represents the students who are applying for the tc

Admin Entity: It represents the Administrator who approve or reject the tc

Relationships:

There are four types of relationships, they are:

One to One, One to Many, Many to One, Many to Many to Many. In this diagram we have Many to
One and One to One relationships.

Attribute: Properties of Entity or Relationship

There are many attributes in the entities like Login, Name etc. Every Entity will have attributes.

8
 7.2 USECASE DIAGRAM

Actors: There are two main actors in the system: the user and the admin. The user is anyone who wants
to apply for a transfer certificate, while the admin is the person responsible for processing the
applications and managing the system.

Use cases:

Login: user and admin will login

Manage forms: Admin will make changes in the forms

Fill the form and Submit: It is done by user

Check Status: User can know the approval or rejection of their tc

View Request: Admin will see the requests which are submitted by user

Approve, Reject: Admin will do this based on user forms

9
 7.3 CLASS DIAGRAM

There are two classes:

User class: Represents the students who are applying for tc

It contains Methods and Attributes

Attribute: Name, Password, Address, etc

Methods: Login(), Submit(), View()

Admin Class: It represents the Administrator who approve or reject the tc

Attributes: Username, Password

Methods: Login(), View(), Approve(), Reject()

10
 8.SOFTWARE DESCRIPTION

Languages used in our project are:

JAVA: Java is used as the primary programming language for the project, providing the backend
logic for the application. The Java programming language is used to handle the business logic of the
application, such as validating user input and processing data submitted through the application form.
Java also handles communication with the database through the JDBC (Java Database Connectivity) API,
which is used to perform database operations such as inserting, updating, and deleting data in the MySQL
database.

HTML: HTML is used to create the user interface for the application. The HTML markup language is
used to create the different elements of the application form, such as text fields, drop-down lists, and
buttons. HTML is also used to structure the layout of the application form and to provide a consistent

visual design across different web browsers.

MYSQL: MySQL is used as the database management system for the project. The MySQL database
stores all of the data submitted through the online TC application form, such as student details, contact
information, educational details, and the reason for applying for a transfer certificate. MySQL is also used

to store and manage the application status and to generate transfer certificates when required.

Together, Java, HTML, and MySQL provide a powerful software stack for developing the "Online TC
Application Form" project. The combination of these technologies enables the application to provide a
seamless user experience while also ensuring the security and reliability of the data submitted through the
application.

11
 9.EXPECTED OUTPUT SCREENSHOTS

USER VIEW:

12
ADMIN VIEW:

13
14
 10.CONCLUSION

This online system of applying provides several advantages compared to physical process of
applying. This process allows students to easily apply their TC and check the status, which
reduces the time. This system provides user friendly interface for the students to apply.
This system will be efficient for the students to apply for TC, eliminating the visit
to college or university. Overall, the development of online system is beneficial for both
students and educational institutions, providing the convenient and efficient way for applying
Transfer Certificate in online.

15
 11.FUTURE SCOPE

 There is a scope for future development of this project. As the technology is increasing day by
day by new methods and functionalities.

 The skill which is prominent today will become obsolete in a few days. To keep equal with the
developed technologies, The system may need to be additionally improved.

 It is not concluded here. It will developed by future technologies. We can even apprise the same
by future changes and can be integrated with minimal alteration.

 This project is flexible and can be developed any time with future features.

16
 12.REFERENCE

https://www.sbtet.telangana.gov.in

https://www.linkedin.com/in/sridharsundararajan

www.iitms.co.in

17