PM SHRI KENDRIYA VIDYALAYA NO.
2 ROORKEE
A Project Report on
DENTAL MANAGEMENT SYSTEM
For SBSC 2026
Examination
[As a part of the Computer Science Course (083)]
SUBMITTED BY
ABHINAV BHATT
Under the Guidance of:
Mrs. SEEMA KESRI
PGT (Computer Science)
CERTIFICATE
This is to certify that the Project entitled DENTAL
MANAGEMENT SYSTEM is a bonafide work done by
ABHINAV BHATT of class XII-A Roll
No………………………..Session 2025-26 in partial
fulfilment of CBSE Examination 2026 and has been
carried out under direct supervision and guidance. This
report or a similar report on the topic has not been
submitted for any other examination and does not
form a part of any other course undergone by the
candidate.
SEEMA KESRI
PGT Comp Sci
EXTERNAL Examiner:
Name: _______________
Signature:
ACKNOWLEDGEMENT
First of all, I am thankful to the Lord almighty whose
enormous grace and blessings enabled us to complete the
Project.
I undertook this Project work, as the part of my class
XII ‘A’- Computer Science course. I had tried to apply my
best of knowledge and experience, gained during the
study and class work experience. However, developing
software system is generally a quite complex and time-
consuming process. It requires a systematic study, insight
vision and professional approach during the design and
development.
I would like to extend my sincere thanks and gratitude
to my teacher [Link] kesri. I am very much
thankful to my Principal Sh. NETRA SINGH for giving
valuable time and moral support to develop this project.
I would like to take the opportunity to extend my
sincere thanks and gratitude to my parents for being a
source of inspiration and providing time and freedom to
develop this software project.
I also feel indebted to my friends for the valuable
suggestions during the project work.
Abhinav bhatt
Class XII-A
CONTENTS
1. Introduction
2. System Implementation
2.1 The Hardware used:
2.2 The Software’s used:
3. System Design &
Development
3.1 Python Coding:
3.2 Output Screen:
3.3 Installation procedure
4. References
INTRODUCTION
The main motto of computerized DENTAL
MANAGEMENT
SYSTEM is to make an automation system for dental
clinic. Technology is a course of study that examines the
method of investigating, executing, and judging the
instructional context and business elements to enhance
business.
This project deals with patients’ records, salary of
employees and management of accounts.
Although this project has been developed with a great
deal of care, research, thought and hard work but still
some smaller and insignificant areas may have been left
unaddressed, so scope has been left for customization.
HARDWARE AND SOFTWARE REQUIREMENTS
[Link] SYSTEM : WINDOWS 7 AND ABOVE
II. PROCESSOR : PENTIUM(ANY) OR AMD
ATHALON(3800+- 4200+ DUAL CORE)
III. MOTHERBOARD : 1.845 OR 915,995 FOR PENTIUM 0R MSI
K9MM-V VIA K8M800+8237R PLUS CHIPSET
FOR AMD ATHALON
IV. RAM : 512MB+
V. Hard disk : SATA 40 GB OR ABOVE
VI. CD/DVD r/w multi drive combo: (If back up required)
VII. FLOPPY DRIVE 1.44 MB : (If Backup required)
VIII. MONITOR 14.1 or 15 -17 inch
IX. Key board and mouse
X. Printer : (if print is required – [Hard copy])
SOFTWARE REQUIREMENTS:
I. Windows OS
II. Python
Python is a high-level language. It is a free and
open- source language.
It is an interpreted language, as Python
programs are executed by an interpreter.
Python programs are easy to understand as
they have a clearly defined syntax and
relatively simple structure.
Python is case-sensitive. For example, NUMBER
and number are not same in Python.
Python is portable and platform independent,
means it can run on various operating systems
and hardware platforms.
Python has a rich library of predefined
functions.
Python is also helpful in web development.
Many popular web services and applications
are built using Python.
Python uses indentation for blocks and nested
blocks.
SOURCE CODE
import
sys
import [Link] as sql
conn=[Link](host='localhost',user='root',passwd='manager')
cur=[Link]()
[Link]("create database dental_management_system")
print("Database created succefully")
conn=[Link](host='localhost',user='root',passwd='manager',databa
se='dental_management_system')
[Link]('create table patient_record( Patient_Name varchar(50),
Age int(3),
Doctor_Conculted varchar(50),
Address varchar(150),
Phone_Number bigint(15))')
[Link]('create table salary_record( Employee_Name varchar(50),
Proffession varchar(20),
Salary_Amount varchar(9),
Address varchar(150),
Phone_Number bigint(15))')
[Link]('create table accounts( User_Name varchar(20) primary
key, password varchar(30) unique)') print('Tables
created successfully')
[Link]()
user=input("Enter New User Name : ")
user=[Link]()
passwrd=input("Enter New Password : ")
passwrd=[Link]()
[Link]("insert into accounts values('" + user + "','" + passwrd
+ "')")
print("ACCOUNT ADDED SUCCEFULLY")
[Link]() if conn.is_connected: print("
Dental Management System ")
print("1. Login")
print("2. Exit") print()
option=int(input("Enter your choice : "))
if option==1: print()
user=input('User Name : ')
user=[Link]()
[Link]("select * from accounts where User_Name like '" +
user + "'")
datas=[Link]() for
i in datas: value_1=i[0]
value_2=i[1] if user==value_1:
password=input('Password : ')
password=[Link]() if
password==value_2:
print()
print('Login succefull')
print()
print("1. Add Patients records")
print("2. Add Salary records") print("3.
Veiw Patient Detail") print("4. Delete
patient detail")
print()
choise=int(input('Enter a option : '))
if choise==1: print()
name=input('Name : ')
name=[Link]() age=int(input('Age
: ')) doc=input('Doctor Consulted :
')
doc=[Link]()
add=input('Address : ')
add=[Link]()
phone_no=int(input('Phone Number : '))
[Link]("insert into patient_record values('"
+ name + "'," + str(age) + ",'" + doc + "','" + add + "'," +
str(phone_no) + ")")
[Link]()
print('Record added') if
choise==2: print()
emp_name=input( 'Employee_Name : ')
emp_name=emp_name.upper()
proffesion=input('Proffession : ')
proffesion=[Link]()
salary=int(input('Salary Amount : '))
add=input('Address : ')
add=[Link]()
phone_no=input( 'Phone_Number : ')
[Link]("insert into salary_record values('" +
emp_name + "','" + proffesion + "'," + str(salary) + ",'" + add +
"'," + str(phone_no) + ")")
[Link]()
print('Record added') if
choise==3: print()
name=input('Name of the patient : ')
name=[Link]()
[Link]("select * from patient_record where
patient_name like '" + str(name) + "'")
data=[Link]()
if data!=0: for
row in data:
print()
print("Patient Details : ")
print()
print('Name : ',row[0])
print('Age : ',row[1])
print('Doctor consulted : ',row[2])
print('Address : ',row[3])
print('Phone Number : ',row[4])
input()
else:
print()
print("Patient Record Doesnot Exist")
if choise==4: print()
name=input('Name of the patient : ')
name=[Link]()
[Link]("delete from patient_record where
Patient_Name like '" + name + "'")
print('Record Deleted Succefully')
else: print('Invalid Password')
print('Tryagain') elif option==2:
[Link]() [Link]() input()
OUTPUT OPTION
– 1:
OPTION – 2:
OPTION – 3:
TESTING
Software Testing is an empirical investigation conducted to
provide stakeholders with information about the quality of the product
or service under test[1] , with respect to the context in which it is
intended to operate. Software Testing also provides an objective,
independent view of the software to allow the business to appreciate
and understand the risks at implementation of the software. Test
techniques include, but are not limited to, the process of executing a
program or application with the intent of finding software bugs.
It can also be stated as the process of validating and verifying
that a software program/application/product meets the business and
technical requirements that guided its design and development, so that
it works as expected and can be implemented with the same
characteristics. Software Testing, depending on the testing method
employed, can be implemented at any time in the development process,
however the most test effort is employed after the requirements have
been defined and coding process has been completed.
TESTING METHODS
Software testing methods are traditionally divided into black box
testing and white box testing. These two approaches are used to
describe the point of view that a test engineer takes when designing
test cases.
BLACK BOX TESTING
Black box testing treats the software as a "black box," without
any knowledge of internal implementation. Black box testing methods
include: equivalence partitioning, boundary value analysis, all-pairs
testing, fuzz testing, model-based testing, traceability matrix,
exploratory testing and specification-based testing.
SPECIFICATION-BASED TESTING
Specification-based testing aims to test the functionality of
software according to the applicable requirements.[16] Thus, the
tester inputs data into, and only sees the output from, the test
object. This level of testing usually requires thorough test cases to
be provided to the tester, who then can simply verify that for a given
input, the output value (or behaviour), either "is" or "is not" the
same as the expected value specified in the test case. Specification-
based testing is necessary, but it is insufficient to guard against
certain risks
ADVANTAGES AND DISADVANTAGES
The black box tester has no "bonds" with the code, and a tester's
perception is very simple: a code must have bugs. Using the principle,
"Ask and you shall receive," black box testers find bugs where
programmers don't. But, on the other hand, black box testing has been
said to be "like a walk in a dark labyrinth without a flashlight,"
because the tester doesn't know how the software being tested was
actually constructed.
That's why there are situations when (1) a black box tester
writes many test cases to check something that can be tested by only
one test case, and/or (2) some parts of the back end are not tested at
all. Therefore, black box testing has the advantage of "an
unaffiliated opinion," on the one hand, and the disadvantage of
"blind exploring," on the other.
WHITE BOX TESTING
White box testing, by contrast to black box testing, is when the
tester has access to the internal data structures and algorithms (and
the code that implement these)
Types of white box testing:-
The following types of white box testing exist:
api testing - Testing of the application using Public and
Private APIs.
Code coverage - creating tests to satisfy some criteria of
code coverage.
For example, the test designer can create tests to cause all
statements in the program to be executed at least once. fault
injection methods. mutation testing methods.
static testing - White box testing includes all static
testing.
INSTALATION PROCEDURE
Dental Management System :-
Pre-Requisites :-
1. You have to have the following softwares for the successful
running of this software; which are
I) Python (Only for the First time), it can be downloadable from
'[Link]'.
II) MySQL (Only for the First time), it can be downloadable from
'[Link]'.
Installation :-
1. There will be two folders namely 'Python Files' and 'EXE files'.
2. The folder 'Python Files' will contain the source code of the
software in python language. If you are running the software by
the 3rd step mentioned below you have to pre install the
following modules :-
I) [Link]
3. Open the files in any python editors and run it to start and work
on the software.
4. The folder 'EXE files' will contain two files namely
'[Link]' and 'Tables_in_mysql.exe'.
5. First run the 'Tables_in_mysql.exe' to create the tables in
MySQL.
1. Then run the file '[Link]' to start and work on the software.
CAUTION :-
If you are running the software through running the python files or
by running the .exe files ; first run the file named
'Tables_in_mysql'.
The .exe file will take a lot of time; so be PATIENT.
BIBLIOGRAPHY
1. Computer science With Python - Class XI,XII By : Sumita Arora
2. A Project Report On Blood Bank Management System (BBMS)
3. Website: [Link]
***