Computer Science
Investigatory
Project-
Dental Management
System
Prajwal Vijay Abhinav Subodh
12 B 12 B
Roll No. - Roll No. -
Vyasa International School Vyasa International School
CERTIFICATE OF AUTHENTICITY
This is to certify that _________________________________________ of
class XII has successfully completed the Investigatory Project on the topic
“______________________________________________________________”
under the guidance of ____________________________________________
for the academic year 2022-2023 in the fulfilment of the Computer Science
practical examination conducted by the All India Senior Secondary
Education.
DATE: ________________
PLACE: ________________
Signature of Signature of Signature of
External Examiner Subject Teacher Principal
ACKNOWLEDGEMENT
I would like to express my special thanks and gratitude to my
computer science teacher Ms. Kavyashree who gave his
immense support and dedicated his time towards this project.
Without his guidance this project would have been
incomplete.
My sincere thanks to our principal Mrs. Hema Nagarajan for
giving us this golden opportunity to do this project on the
topic ‘Dental management System’.
I thank my classmates for their timely help and support for
compilation of this project. Last but not the least, I would like
to thank all those who have helped directly or indirectly
towards the execution and culmination of this project.
INDEX
Sl Topic Page
No. No.
1. Cover Page 1
2. Certificate 2
3. Acknowledgement 3
4. Introduction 5
5. Functionality and Modules 6
6. Hardware and Software 7
specifications
7. Header Files 8
8. Algorithm 9
9. Flowchart 10
10. Source Code 11
11. Output 15
12. Bibliography 19
INTRODUCTION
The Project is useful for the owners of clinics to keep track of the
doctors along with their respective patients.
In this software, one can add patient records, salary records and
retrieve them when required, it allows multiple doctors to save their
respective records
Objective -
The objective of this project is to reduce the labour or the hectic
work for the doctors and the clinic owners. This way, the time and
work required is less. This system has some features:
• User friendly
• Time efficient
• Cost efficient
• Easy performance check and generation of daily reports
• it keeps the data of the customer secure.
• Paper work is also not required.
Functionality -
Using this system, the user can:
Create Logins for multiple doctors
Addition of Patient records
Addition of Finances of the patient
Deletion of Patient records
Modules -
1. Creating logins for multiple doctors -
Asks for the name of the doctor, password for the
particular doctor, and enters the values into the database
2. Entering Patient records -
Asks for the name, address, phone number, age, doctor
consulted and address
This data is later stored in patient_record table
3. Entering Financial records -
Asks for the name, salary, phone number and profession
of the patient
This data is stored in salary_record table
4. Deleting records -
Asks for the name of the patient
And deletes the records of the patients (Both Financial
and normal records)
HARDWARE AND SOFTWARE
SPECIFICATIONS
HARDWARE:
Processor: Intel(R) Core(TM) i5-10210U CPU @ 1.60GHz
2.11 GHz
RAM : 8.00 GB
Printer: HP Deskjet 1510 series
System type: 64-bit operating system, x64-based processor
SOFTWARE:
Operating system: Linux 20.04.1
Python: Terminal with python3 and notepad
MySQL: MySQL 8.0 Command Line Client
Google Docs: For presenting the project work
HEADER FILES
MySQL 8.031:
To create a database for the Project.
[Link]:
Provides connectivity to the MySQL server and the
program
ALGORITHM
Step 1: Create an account for each doctor working
the the clinic
Step 2: Choose any one of the four options as per
the requirements
Eg. Adding Patient Record
Step 3: Enter Name
Step 4: Enter Age
Step 5: Enter name of Doctor Consulted
Step 6: Enter Address
Step 7: Enter Phone Number
Hit enter, and your record has been saved
FLOWCHART
SOURCE CODE
ACCOUNT [Link]
import sys
import [Link] as sql
conn=[Link](host='localhost',user='root',passwd='vijay',database='dent
al_management_system')
cur=[Link]()
if conn.is_connected:
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 SUCCESSFULLY")
[Link]()
DATABASE [Link]
import sys
import [Link] as sql
conn=[Link](host='localhost',user='root',passwd='vijay')
cur=[Link]()
if conn.is_connected:
[Link]("create database dental_management_system")
print("Database created successfully")
[Link]
import sys
import [Link] as sql
conn=[Link](host='localhost',user='root',passwd='vijay',database='dent
al_management_system')
cur=[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 succeful')
print()
from time import gmtime,strftime
a=strftime("%d %b %Y",gmtime())
b=strftime("%H %M %S",gmtime())
c=strftime("%a ",gmtime())
print('Date : ',a)
print('Day : ',c)
print('Time : ',b)
print()
print("1. Add Patients records")
print("2. Add Salary records")
print("3. Veiw Patient Detail")
print("4. Delete patient detail")
print()
choice=int(input('Enter a option : '))
if choice==1:
print()
print("Patient Details : ")
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 choice==2:
print()
print("Employee Details : ")
print()
emp_name=input('Employee_Name : ')
emp_name=emp_name.upper()
profession=input('Profession : ')
profession=[Link]()
salary=int(input('Salary Amount : '))
add=input('Address : ')
add=[Link]()
phone_no=input('Phone_Number : ')
[Link]("insert into salary_record values('" +
emp_name + "','" + profession + "'," + str(salary) + ",'" + add + "'," +
str(phone_no) + ")")
[Link]()
print('Record added')
if choice==3:
print()
name=input('Name of the patient : ')
name=[Link]()
[Link]("select * from patient_record where
patient_name like '" + str(name) + "'")
data=[Link]()
[Link]("select * from salary_record where
employee_name like '" + str(name) + "'")
data2=[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])
else:
print()
print("Patient Record Doesnot Exist")
if data2!=0:
for row in data2:
print('Profession : ',row[1])
print('Salary Amount : ',row[2])
else:
print()
print("Salary Record Doesnot Exist")
if choice==4:
print()
name=input('Name of the patient : ')
name=[Link]()
[Link]("delete from patient_record where
Patient_Name like '" + name + "'")
[Link]("delete from salary_record where
employee_name like '" + name + "'")
print('Record Deleted Successfully')
else:
print('Invalid Password')
print('Try Again')
elif option==2:
[Link]()
[Link]()
input()
TABLES [Link]
import [Link] as sql
conn=[Link](host='localhost',user='root',passwd='vijay',database='dent
al_management_system')
cur=[Link]()
[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),Profession 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]()
OUTPUT
Logging in -
Adding Patient records -
Adding Salary Records -
Viewing records -
Deleting records-
As it can be seen the record patient 2 has been deleted
BIBLIOGRAPHY
● Computer Science with Python- a Textbook for Class 12 by Sumita
Arora
● [Link]
● [Link]
● [Link]