CERTIFICATE

This is to certify that Ansh Sharma of

class: XII-A of SG PUBLIC SR SEC SCHOOL
has done his project on PHARMACY
MANAGEMENT SYSTEM under my supervision.
He has taken interest and has shown at most
sincerity in completion of this project. I certify
this project up to my expectation & as per
guidelines issued by CBSE.

Internal Examiner External Examiner

Principal
 L

ACKNOWLEDGMENT

It is with pleasure that I acknowledge my

sincere gratitude to our teacher, Mrs.
Kavita Mohapatra who taught and undertook the
responsibility of teaching the subject computer
science. I have been greatly benefited from her
classes. I am especially indebted to our Principal
Mrs. KavitaKehri who has always been a source
of encouragement and support
and without those inspirations this project
would not have been a successful I would
like to place on record heartfelt thanks to
her.
Finally, l would like to express my
sincere appreciation for all the
other students for my batch their
friendship
& the fine time that we all shared together.
 HARDWAR£S AND
SOFTWARESREQUIRED
HARDWARES
1. Desktop Computer / Laptop
2. Mobile Phone

SOFTWARES
1. Python (latest version)
2. MySQL
3. Python Connector Module
 L

INDEX
[Link]. TOPIC

1. Certificate
2. Acknowledgement
3. Hardware and software
required
4. Introduction
5. Python Source Code
6. MySQL Database
7. Outputs
8. References
 INTRODUCTION
The pharmacy management system, also
known as the pharmacy information system,
is a system that stores data and enables functionality
that organizes and maintains the medication use
process within pharmacies. These systems may be an
independent technology for the pharmacy's use only,
or in a hospital setting, pharmacies may be integrated
within an inpatient hospital computer physician order
entry (CO€) system. Necessary actions
for a basic, Functioning pharmacy management
system include a user interface, data entry and
retention, and security limits to protect patient health
information. Pharmacy computer
software is usually purchased ready-made or provided
by a drug wholesaler as part of their service. Various
pharmacy software operating systems are common
place throughout the
many practice settings.

.
 In conclusion, the Pharmacy Management
System is a vital tool for modernizing and
optimizing pharmacy operations. Its
implementation results in increased efficiency,
reduced errors, improved patient care, and
enhanced overall business management. As the
healthcare industry continues to evolve,
embracing technology through systems like
PMS becomes imperative for pharmacies to
stay competitive and provide high-quality
services. The continual advancement of such
systems ensures that pharmacies can adapt to
changing regulatory requirements and
technological advancements, ultimately
contributing to better healthcare outcomes for
patients.
" •-.! pg i Ł{” hon r Y.- '”.I[ 4 4 ]]
prI/•ri-i° :‹ r” -,i[ 1s]I
pj |„ ' • • ... . . . . . .. . . . .. . . .... . .. . . . . .. . . , ...................................... • •
°' ’ d. agmmlt0

11 i t. oxzeułaf” 4øIce i”fronJ Lu\u loye• ”}

 Buy Med Icone[}

': ' ch••l:

a+: :n+<h °m
á'l UDKE{)
 PHARMACY
MANAGEMENT
SYSTEM
MEDICINE TABLE
ORDERED DRUG
TABLE
SEARCH MEDICINE
TABLE
CHECK STOCK
TABLE
EMPLOYEE TABLE
CUSTOMER TABLE
 L

• RES TA RT. D:tCS PRI \groUpB. py

------- !t PHARMACY MANAGEMENT SYSTEM II ------------
••••”••••"“WELC OME’““••••”•••••
.A D MTB .-
!.USER--
[Link]:•
....• •••....} Q KYOU”“” •....•.....

"* ADMIN MENU ”“

. Add Ordered drugs.•

.Ordered drugs!-
t.n free k gtock:-
'. Add EmpToyee.-
I Em la ee:•
’.Add Cus tamer:-
I.C ustome r:-
*.Exit:•
"”” THANK YOU "•“
.nier y ou r nh oIne :-
1. ADMIN:-
2. U8ER:-
3. EXIT:-
THANKYOU•"• •-—
Enter Who Are You:- 1
”ADMIN MENU ”
•••
1.Add_Drugs:-
2.Add_Ordered_drugs:-
3.Orderad_drugs:-
4.check_9tock:-
6.Add_Empleyee:-
[Link]:-
7.Add_Customer:-
[Link]:-

” THANK YOU ”
Enter your choice :- 1

Enter g_NO: 11
Enter PrescrIptIon„lD: 468892483
Enter Batch„Number: 46316
Enter Drug_Name: Gellv_da
Enter Company_Name: clpla
Enter Company_Code: 0123
Enter Drug_Tgpa: liquid
Enter Uses: diarrhea
Enter Prlce: 1600
Enter 9tock: 520
Row Inverted successfully....
Do you want to entar more records ?(Y/N)no
 ”’ THANK YOU ” ”
Enter your choice :- 3

""""” ORDERED DETAILS ""”’•“

Ever keyword to Ordersd_dru s :- n

Order_lD: 12125
Drug_Name: nopaln
Drug_Type: llquld
Ordersd_quantlty: 2

Cuatemer_Name: subhaahree
Phone_no: 946832666
Address: sector_16_Delhl
--• --”””THANK YOU FOR ORDER”*• --- •

Order_iD: 12340
Drug_Name: ambrodll
Drug_Typa: llquld
Orderad_quantlty: 2

Cuatomer_Name: subhaamlta
Phone_no: 946666466
Address: eector_2_Mumbal
------ •THANK YOU FOR ORDER *--------

Order_lD: 126S6
Drug_Name: aetu_nuPItlon
Drug_Typs: capsule
Orderad_quantlty: 6

Cuetomer_Name: rahuI_mIshra
Phone_no: sg2636461
-- -- * THANK YOU FOR ORDER “- --—

Order_lD: 168d2
Drug_Name: Blotln
Drug_Type: tablet
Ordersd_quantlty: 1

Cuatomer_Name: Raahmlta
Phone_no: 94741268
Addresa: sector_2_chandlghar
- — -—““”THANK YOU FOR ORDER ” —--

Order_lD: 48237
Drug_Name: ambrodll
Drug_Type: liquid
Ordersd_quantlty: 2

Cuatomer_Name: Trlcha
Phone_no: 99631478
Address: Blg_mall_road_mumbal
-- --—-* THANK YOU FOR ORDER ”-— --—

Order_lD: 66842
Drug_Name: Blotln
Drug_Type: tablet
Ordered_quantlty: 1
Price: 230
Cuatomer_Name: Anklt
Phone_no: 92586486
Address: new_sector_madras
-- -- “ THANK YOU FOR ORDER “-— ---
Order_lD: 66676
Drug_Name: Pantop_drs
Drug_Type: Capsule
Orderad_quantlty: 2

Cuatomer_Name: Nldhl
Phone_no: ee731se
Address: Mall_road
—-- - *””THANK YOU FOR ORDER ”-- ---

Order_lD: 66416
Dru Name: Pantop_drs
Drug_Type: Capsule
Ordered_quantlty: 2

Customer_Name: Rahul
Phone_no: 9973165
Address: Mall_road
- -- - ”THANK YOU FOR ORDER’”’- - -- -

Order_lD: 96347
Drug_Name: Mats_excel
Drug_Type: Nblet
Ordered_quantlty: 3
Price: 350
Customer_Name: Tlnu
Phone_no: 9123S448
Address: 3_asctor„pune
- - - ”THANK YOU FOR ORDER ’- --- - -

[Link] Drues:-
[Link]:-
* THANK YOU •*
Enter your choice :- 4

6_NO: 10
Drutl_Name: nopaln
Batch_number: 999B6
Manufacturor_Dats: 2019-06-26
Explry_Dats: 2023-01•06
6tock: 600
Drug_Name: Pantop_mps
Batch_number: d6d86
Msnufacturer_Date: 2012-08-22
ExpIry_Date: 2017•07-24
Stock: 40
Price: 150
›‹»‹›
Drug_Name: Asozen_Forte
Batch_number: 25665
Manufacturer_Date: 2011-01-24
ExpIry_Dato: 2032•07-14
9tock: 120
Price: 20

••• G G Gw•
S_NO: 1
Drug_Name: Biotin
Batch_number: 3S405
Manufacturer_Data: 2021-11-04
Explry_Deta: 2026-12-06
Stock: 47

9_NO: 3
Drug_Name: Mate_excel
Batch_number: 79136
Manufacturer_Date: 2008-06-05
1.Add_Drugs:-
2.Add_Orderad_drugs:-
3.Ordercd_drugs:-
4.check_Stock:-
5.Add_EmpIoyee:-
[Link]:-
7.Add_Customer:-
[Link]:-
[Link]:-
* * THANK YOU
Enter your choice :-
 L

".." --—--—-- !I PHARMACY MAN AGEM EN T_S ¥6 TEM !! -——--—- . ---------- '” " ” “
’ " "WELC OF E’ ” " -- -•’ ---- -

2. M 5E R :-
3. EXIT:-
--” " ” ----THANKYO U" “ ----” --—-
Engel Whe The Yo u • t
• “ ADMIN MG MM " ”

[Link] d Dru g s. •

3. Orderea_drugs:-
4. chat k_Stonk:-
5. Ad d E mpIc‹yojj :.
6. Em pl oyee :•

[Link] It:-
"”" THANK YOu ’"’’

End r 5aI ary: 46Q00

Enter Ph one no: T 3B748628
Ert\cr Aaareee : Mumoa I
"""*"* EMPLOYEE DETAILS """""
Enter keyword to Employee :- n

EmpIoyee_ID: 98
EmpIoyee_Name: Rajech_Kumar
Role: Manager

EmpIoyee_ID: 07
Employes_Name: Anurag_Podar
Role: Manager
Salary: 95000
Phone_no: 741e63208
Address: sector_A_MumbaI
»

EmpIoyee_ID: 28
EmpIoyee_Name: Anl‹lt_szmal

EmpIoyce_ID: M
EmpIoyee_Name: 9ujIta_Majhl
Role: ¥\forker
9alary: 14000
Phons_no: 147862369
 L

— — II PHARMACY MA NAGEMENT_SY 6 TEM II - - - ..--------- “*”“*”“

— * —-” "’WELC OME" ”—--”-—--
1. ADM IN!-

"“" A D MTN MEkU "*

1. Add Oruge:-

[Link].-
[Link] C uezomer: -
B.C uatomer:-
[Link]: -
” "" ’ THANG YOU "”" ”
Entef' yOUY Cfi4 IU :• 7

..... ..... ..... .. . .. ..... ..... .. ..... ........ .. ..... ..... .. ........ .. ..
Enter S MO: 41
Enter C uezome r Marne: Lokashree
Enter Phone_no: M8882 157
Enwr Ad drew a: Puna
Row meaned eucceaaf ugly....
 * THANK YOU *
Enter your choice :- 8

"•”“" CUSTOMER DETAILS ^ ^

Enter keyword to Customer :- a

6„NO: 1
Customer_Nams: RanjIt_Daah
Phone_no: 468e67129
Address: Navi Munbal

8_NO: 2
Cuatomer Name: Anklta 8amal
Phone_no: 7411476d2
Addreee: Dadar Munbal

9_NO: 3
Customer_Name: saawatee_Bshera
Phone_no: 3e0852369
Addreee: Hajl AII_MunbaI

g_No: 4
Customer_Name: KIron_Bshera
Phone_no: 741265741
Address: ShIvsjI_Park_Munbai

B_No: s
Customer_Nams: HImansu_9etty
Phone_no: 852369g52
Address: IaIa_Ia)pat_Nagar_MunbsI
s_No: 6
Cuetomer_Narne: Mahlma_mayce
Phone_no: 7A96M123
Address: Secto _A_Puna

s_No: 7
Customer_Narne: RatIah_8ahu
Phone_no: 763951462
Address: Sector_A_Puna

a_ o: s **" "
Customer_Narne: PrIyanka_Maharana
Phone_no: 159367426
Address: 9ector_B_NasIk

s_ o: e **" ”
Customer_Name: 9ubhashree_Mlshra
Phone_no: 369741258
Addreea: Sector B Naslk
»‹
9_NO: 10
Customer„Narnc: PrItam„Kumar
Phone_no: 123852664
Address: sector A Chandigarh

9_NO: 11
Customer_Narna: kIron_maharana
Phone_no: 1478S214d
Address: Juhu_MumbaI
« ww. «
8_NO: 12
Customer_Name: RahuI_PattnaIk
Phone_no: 802569647
Address: Juhu_MumbaI

9_NO: 13
Customer_Name: AnII_Pattnaik
Phone_no: 456985231
Address: Mumbai

s_No: 1s
Customer_Name: AnII_Pattnaik
Phone_no: 406967123
Addrsae: Dadar_MumbaI

S_NO: 16
Customer_Name: Bandeep_Roy
Phone_no: 466802173
Address: Dadar_MumbaI

S_No: 16
Customer_Name: RahuI_DaIaI
Phone_no: 652406951
Address: ‹sandhI_nagar

S_NO: 17
Customer_Name: Mohlt_mlsra
Phonc_no: 654852351
Addreas: Sector_A_Mumba
9_NO: 16
Customer_Name: 9Imran_Pradhan
Phone_no: 753951426
Address Hlllpatna

G_NO: 18
Customer_Name: BImran_Padhy
Phone_no: ¥66987789
Address: Pune

9„NO: 20
Customer_Name: MahIma_Gahu
Phone_no: 496664406
Address: Juhu_MumbaI

9_NO: 21
Customer_Name: 9aIonI_Patro
Phone_no: 333666672
Address Dadar_Mumbai

s_No: 22
Customer_Name: SamIra_Patro
Phone_no: 368652256
Address: Patna

C_NO: 23
Customer_Name: Abhlra_charma
Phone_no: 40666S231
Address: New_DeIhI

9 NO: 24
S_NO: 24
Customer_Name: MohIt_Kumar
Phons_no: 466901703
Address: Jaipur

S_NO: 25
Customer_Name: AbhIya_Sharma
Phone_no: 654654654
Address: Jaba ur_MP
S_No: 26
Customcr_Name: KIara_Goenka
Phone_no: 700825700
Address: RaIpu
i

9_NO: 27
Customer_Name: Mahlma_AdanI
Phone_no: 666974123
Address: Gurgaon_DeIhI

s_No: 26
Customsr_Nams: Ojasvtnl_PanlgrahI
Phone_no: 967412356
Address: Man pur
a_NO: 29
Customer_Name: Samiatha_Patro
Phone_no: B439721S6
Address: Kashmir

9_NO: 30
S_NO: 27
Cueæmer_Nama: MahÎm•_AdanI
Phone_no: gS6974123
gddreec: Curgaon_Dalhi

s_ o: æ
cuctomer_Name: ojasvInI_Panlgrahl
Phone_no: 96741236d
gddress: Manipur

s_NO: Z9
Cu0tO yie‹’_N8iy›e: &S‹z›!Stho P®ô’O
Phone_no: g43972166
pztdreas: Kaahmlr

s_No: 3o
Cuctomer_Nams: si*eetai_s•hM
Phone_no: 1234b0769
Address: Puns
»
1.Add_Dctzga:-
2.Add_Ordered_drug+:-
[Link]•rsd_druga:-
•
6.Add_Employee:-
[Link]:-
7.Add_Customsr:-
[Link]:-
[Link]:-
”•• THANX YOU “****
’Enær your cholce :-
8_NO: 30
Cuctomer_Name: Sheetal_9ahu
Phone_no: 123458769
Address: Pune

1.Add_Drugs:-
2.Add_Ordersd_drugs:-
3.Ordersd_druge:-
4.check_Stock:-
6.Add_EmpIoyee:-
[Link]:-
7.Add_Cuetomef:-
[Link]:-
[Link]:-
* THANK YOU ""*
Enter your choice :- 9

*-— *WELCOME* *-
1. ADMIN:-
2. U9ER:-
3. EXIT:-
”””* THANKYOU’””” ”-
Enter Who Are You:- 2
”^ USER MENU “”
•••
1.9sarch_MedIcIne:-
2.Buy_MedIcIne:-
[Link]:-
• THANK YOU ""*
Enter Your Cholce•-I
 * THANK YOU •
Enter Your Choice:- 2

“* * MEDICINE DETAILS *
Enter the Drug_Name : a

G_NO: 10
Prsscrlption_ID: 231660134
Drug_Name: nopaln
Price: 450

C_No: 7
Prsscrlptlon_ID: 296678606
Drug_Nams: ambrodll
Price: 1S0
4_No: e
Prsscrlption_ID: 362165012
Drug_Nama: dextromethrophan
Price: 600

S_No: 5
Prescrlption_ID: 629610022
Drug_Name: Pantop_mps
Price: 160

S_NO: 2
Prescrlption_ID: 663986726
Drug_Name: Asoaen_Forte
Prlce: 20
“ P”C ¥¥eS . ¥M¥d

6_No: g
Pr«acrlptlon_ID: 52961N22
Drug_Namc: Pantop_mps
Prlce: 1b0

s_NO: 2
Prsscrlptlon_
Dru Name: Acozan_Forte

S_No: 6
Preaarlptlon_ID: 1237621629
Drug_Name: nefro_save_keto
Prlce: 210
s_No: 3
Prcccrlptlon_ID: 12¥9b63208
Drug_Namc:

s_No: «
Prascrlptlon_ID: 1324690132
Drug_Nams: Pantop_drs
Prlc«: z00
•
1.8sarch_MadicIns:•
2.Buy_ModicIna:-
[Link]:-
”•”•” THANK YOU °““°“
 L

REFERENCES
1. News API
[Link]
2. Wikipedia
https: [Link]
3. Python
https: www.;;[Link]
4. MySqL
https: [Link]
5. Class 11th & 12th Computer
Science Arihant Books.