A

THESIS REPORT
ON
“CERTIFICATE MANAGEMENT SYSTEM”

Submitted in partial fulfillment of the requirement for the award of degree

of

BACHELOR OF TECHNOLOGY
IN
INFORMATION AND TECHNOLOGY ENGINEERING
BY
YANAGANDHULA VARUN (20R91A1248)

Under the esteemed guidance of

Mrs. e.aruna
Associate Professor

Department of Information and Technology Engineering

TEEGALA KRISHNA REDDY ENGINEERING

COLLEGE(AUTONOMOUS)
 Accredited by NAAC with ‘A’ Grade, Accredited by NBA, Appropoved by
AICTE, Affliliated to JNTUH . Medbowli , saroornagar, Hyderabad-500097
C

CERTIFICATE

This is to certify that the thesis report entilted

“CERTIFICATE MANGEMENT SYSTEM”

YANAGANDHLA VARUN
(20R91A1248)

Of B.TECH (INFORMATION AND TECHNOLOGY ENGINEERING) under our supervision during

the accademic year 2021-2024 in partial fullfillment of the requirement for the award of
degree Bachelor of Technology in the Department of Information and Technology
Engineering , TKREC, under jawaharlal Nehru Technological unviresity, Hyderabad, is a
record of bonafide work carried out by him

Supervisor Head of Dept of IT

Mrs. E.Aruna DR.J.Praveen Kumar
(Associate proffesor) (proffesor)

DECLARATION
This is to declare that the work which is being presented in this thesis report
entilted “CERTIFICATE MANANGEMENT SYSTEM” towards the partial
fullfillment for the award of Bachelor of Technology in Information and
Technology Engineering , is an authentic record of my own work out under
the guidance of E.ARUNA, Associate professor, Teegala krishna Reddy
Engineering college.
The matter emboided here, has not been submitted by me for the
award of any other degree

Y.VARUN (20R91A1248)
 ACKNOWLEMENT
This thesis entilted “CERTIFICATE MANAGEMENT SYSTEM” is
succesfully accomplished with the assistance from varoius sources especially
from the staff of the department of Information and Technology Engineering
of Teegala Krishna Reddy Engineering college .

I specially thank my supervisor MRS. E.ARUNA, Associate professor,

Department of IT for constantly monitoring my progress and suggesting
improvements at various stages for preparing the thesis report .

I would like to thank MR.DR.J.PRAVEEN KUMAR, HOD of IT department,

for his valuable help during the thesis report.

I would like thank MR.DR.K.VENTAKA MURALI MOHAN, Principal ,

Teegala krishna reddy engineering college for havimg perimitted me to take
on this thesis report.

Y.VARUN (20R91A1248)
 ABSTRACT
A certificate will encourage the students to achieve
more in their curriculum or co-curriculum. It will be a
recognition give to the student his or her excellence in
some or the other field. The database must be strong
enough to hold the certificates of all the students of the
institutions.
The student needs to login to the application using the
username and password. The data is stored will be safe
through this application. It will not be misused. Only the
authorized users will be having access to this
application. This will be one of the applications that one
can implement in real time world. The user interface
must be simple and easy to understand.
 INDEX
Title i
Certificate of guide ii
Declaration of the student iii
Acknowledgment iv
Abstract v

1. INTRODUCTION
01
1.1 RECURIMENTS 02
1.2 EXISTING & PROPOSED SYSTEM 04
1.3 ENTITIES 05
1.4 RELATIONS
06
1.5 MYSQL DATABASE 07

2.E-R MODEL 08

3.REALTONAL MODEL
4.LOGICAL DATABASE DESIGN
5.OUTPUT SCREENS
6.FUTURE ENHANCEMENT
7.CONCLUSION
8.REFERENCE
 CHAPTER 1. INTRODUCTION

This chapter introduces Netscape Certificate Management System (CMS),

a highly configurable set of software components and tools for creating,
deploying, and managing certificates. Based on open standards for
certificate management, Certificate Management System leverages
Netscape Directory Server and Netscape Console to provide a complete,
scalable, high-performance certificate management solution for extranets
and intranets.

Whether you are looking for a security solution for your enterprise or
setting up an independent certificate authority (CA) service, Certificate
Management System offers a robust, customizable, and scalable
foundation for your public-key infrastructure (PKI).
REQUIREMENTS

Requirements are :
Software Requirement Specification
Hardware Requirements are:
Pc with Pentium IV processor.
512 GB RAM or above.
40 GB Hard Disk or above.
Softwafe Requirqments:
Operating system : Windows XP(latest)
Front end : Java runtime
Platform : Java swings
Intragated development envirnoment(IDE) : Eclispe
Back end : oracle 10g
Database Design
Conceptual design
 EXISTING ANG PROPOSED SYSTEM

EXISTING SYSTEM :

In the Existing system all certicicates were created by manually which

consumes more time

Cetificates are prepared manually as and when needed, maintaining of

certificates is very difficult and tedious task

If certificate is lost or damaged then user has to collect the another copy
of that from the istitution or college.

PROPOSED SYSTEM :

This system is very in design and implement. The system reuires very low
system resources an the system will work in almost all configurations.
It has following features:

 Formulates, signs, and issues industry-standard X.509 version 3 public-

key certificates; version 3 certificates include extensions that make it
easy to include organization-defined attributes. This means that you can
use these certificates for extranet and Internet authentication as well.
 Supports signature key lengths of up to 1024 bits (DSA) and 4096 (RSA)
on both hardware and software tokens.
 Supports multiple message formats, such as KEYGEN/SPAC,
CRMF/CMMF for certificate requests. All requests are delivered to
Certificate Management System over HTTP or HTTPS; in the case of
CRS/CEP/SCEP protocol, the delivery method is always over HTTP.
ENTITIES

1.USER

User name User moblie

User id

USER

User email User

addresss
LOGIN :

Login_role_id
Login_id

LOGIN

Login_user_name User password

ROLES:
 Role name

Role_desc

ROLES

Role id

PERMISSION:

#Per_id Per_role_id

PERMISSION

Per_module
Per_name

STUDENT:

#stu_id
Stu_pass Stu_name
 STUDENT

Stu_moblie Stu_email
Stu_add

ISSUSE CERTIFICATE:

Issu_desc Issu_exp
Issu_stu_id

ISSUSE

CERTIFICATE

#issu_date Issues id

CERTIFICATE TYPE:

#ct_id

Certificate type Ct_desc

Ct_type
UNVIRESITY:

Uni name #uni_id

Uni_desc

UNVIRESITY

Uni_type Uni_place
MYSQL DATABASE:

MY SQL: is an open -source relational database management system(RDBMS).

It is the most popular database system used with PHP. MYSQL is developed,
distributed, and supported by oracle corporation. The data in MYSQL database
are stored in tables which consists of columns and rows.
 2.ER-MODEL:

Login_role_id

Login_user_name
User password

User moblie Login_id

User id
Role name
LOGIN
Role_desc
USER
User name has ROLES Role id

User email Per_name

#Per_id
User addresss

PERMISSION
Per_role_id

Per_module

Stu_moblie

Stu_pass
manage
 Issues id
Stu_email Uni_place

ISSUSE #issu_date
Uni name

Stu_add
STUDENT CERTIFICATE
Issu_stu_id
UNVIRESITY

Issu_exp
has
Ct_desc Uni_type
Issu_desc

#uni_id
Uni_desc
Certificate type
Ct_type

#ct_id

3. REALTIONAL MODEL:
4.LOGICAL DATABASE DESIGN:
6.OUTPUT SCREENS:
7. FUTURE ENHANCEMENT:
9.REFERENCES: