Dental Clinic Management System
, DentalClinicManagementSystem
Tableofcontents
1. Project Proposal..........................................................................................................1
Introduction……………………………………………………………....
2
Background…………….
………………………………………………...3
ProblemStatement.............................................................................4
LiteratureReview
….................................................................................8
FeasibilityStudy
…................................................................................14
2. SystemAnalysis........................................................................................................17
ProjectMethodology…....................................................................................17
ExistingSystem………….
……………………………………………...22
ProposedSystem..............................................................................26
3. SystemDesign….........................................................................................................33
DatabaseDesign…………………………………………………………
33
UserInterfaceDesign………………………...…….…………………… 48
4. SystemImplementation…...........................................................................................50
Snapshotsofforms&Report..........................................43
5. SystemTesting…........................................................................................................44
Typesoftesting………………………………………………………….. 45
Page1
, DentalClinicManagementSystem
Objectiveoftesting…....................................................................46
TestCase....................................................................................................
47
INTRODUCTION
The World Health Organization defines Dentistry as "the science and art of preventing,
diagnosingandtreatingdiseases,injuriesandmalformationsoftheteeth,jawsand mouth".
Dentistsdiagnoseandtreatproblemswithteethandtissuesinthemouth,alongwithgiving advice and
administering care to help prevent future problems.
They provide instruction on brushing, flossing, the use of fluorides, and other aspects of
dentalcare.Theyremovetoothdecay,fillcavities,examineXrays,placeprotectiveplastic sealants
on children's teeth, straightenteeth, and repair fracturedteeth.They also perform
correctivesurgery on gums and supporting bones to treat gum diseases.
Dentistsextractteethandmakemodelsandmeasurementsfordenturestoreplacemissing teeth. They
also administer anesthetics and write prescriptions for antibiotics and other medications.
Dentalhealthcentersareimportantbecausetheyprovidecrucialservicestothesociety,soitis necessary to
automate their work process in order to enhance the quality of their service.
Sincemostofourdentalclinicsworkmanualsystem,anditisveryhardtokeeptrackthe health situation of
the patients in an order manner with time to time.
Atthattimeitisworthwhiletomakeadatabasesystemthatsafeandkeeptrackthe information of the
patients as well as simplify their work up to extent.
Page2
, DentalClinicManagementSystem
The other reason why it is important for dental clinics to have a database system is that
patientswithdentalproblemsmighttakelongtimetocureandvisitstheirdoctors/consultants more
than one time, so the dentisthave to follow up their treatment history properly to provide the
best treatment type.
BACKGROUND
DrRamadanDentalClinic
DrRemadanDentalClinicandpharmacyisestablishedin1997inHarercitysincethereitis the most
famous and leading dental clinics in Somaliland.
DrRemadanDentalClinicisprivatelyowneddentalclinicbydentistDrRemadan,providing dental
services in Somaliland.
Dr Remadan dental clinic principal activities include flossing, the use of fluorides, remove
toothdecay,fillcavities,examineXrays,placeprotectiveplasticsealantsonteeth,straighten teeth,
and repair fractured teeth. They also perform curative surgery on gums and supporting bones
to treat gum diseases.
ThedentalclinicissmallinsizeandhasnobranchesinotherregionsofSomaliland,onlyone dentist Dr.
Dr Remadan which is also the owner, work the clinic and two of his assistants.
Thedentalclinicworks11/5everydayexceptweekends,thedentistworktwo shifts.
In the morning the dentist check patients that has already examined and described their
problem,whileintheafternoonthedentisttriestoreceiveandseethecomplaintsofatleast 50 patient.
ApartfromDrRemadanDentalClinic,therearemanyotherdentalclinicswhichprovidethe same
service to the society, but the reliable knowledge of Dr.Abokor and his team made the clinic
the most famous and customer oriented dental clinic in Somaliland.
Page3
, DentalClinicManagementSystem
Tableofcontents
1. Project Proposal..........................................................................................................1
Introduction……………………………………………………………....
2
Background…………….
………………………………………………...3
ProblemStatement.............................................................................4
LiteratureReview
….................................................................................8
FeasibilityStudy
…................................................................................14
2. SystemAnalysis........................................................................................................17
ProjectMethodology…....................................................................................17
ExistingSystem………….
……………………………………………...22
ProposedSystem..............................................................................26
3. SystemDesign….........................................................................................................33
DatabaseDesign…………………………………………………………
33
UserInterfaceDesign………………………...…….…………………… 48
4. SystemImplementation…...........................................................................................50
Snapshotsofforms&Report..........................................43
5. SystemTesting…........................................................................................................44
Typesoftesting………………………………………………………….. 45
Page1
, DentalClinicManagementSystem
Objectiveoftesting…....................................................................46
TestCase....................................................................................................
47
INTRODUCTION
The World Health Organization defines Dentistry as "the science and art of preventing,
diagnosingandtreatingdiseases,injuriesandmalformationsoftheteeth,jawsand mouth".
Dentistsdiagnoseandtreatproblemswithteethandtissuesinthemouth,alongwithgiving advice and
administering care to help prevent future problems.
They provide instruction on brushing, flossing, the use of fluorides, and other aspects of
dentalcare.Theyremovetoothdecay,fillcavities,examineXrays,placeprotectiveplastic sealants
on children's teeth, straightenteeth, and repair fracturedteeth.They also perform
correctivesurgery on gums and supporting bones to treat gum diseases.
Dentistsextractteethandmakemodelsandmeasurementsfordenturestoreplacemissing teeth. They
also administer anesthetics and write prescriptions for antibiotics and other medications.
Dentalhealthcentersareimportantbecausetheyprovidecrucialservicestothesociety,soitis necessary to
automate their work process in order to enhance the quality of their service.
Sincemostofourdentalclinicsworkmanualsystem,anditisveryhardtokeeptrackthe health situation of
the patients in an order manner with time to time.
Atthattimeitisworthwhiletomakeadatabasesystemthatsafeandkeeptrackthe information of the
patients as well as simplify their work up to extent.
Page2
, DentalClinicManagementSystem
The other reason why it is important for dental clinics to have a database system is that
patientswithdentalproblemsmighttakelongtimetocureandvisitstheirdoctors/consultants more
than one time, so the dentisthave to follow up their treatment history properly to provide the
best treatment type.
BACKGROUND
DrRamadanDentalClinic
DrRemadanDentalClinicandpharmacyisestablishedin1997inHarercitysincethereitis the most
famous and leading dental clinics in Somaliland.
DrRemadanDentalClinicisprivatelyowneddentalclinicbydentistDrRemadan,providing dental
services in Somaliland.
Dr Remadan dental clinic principal activities include flossing, the use of fluorides, remove
toothdecay,fillcavities,examineXrays,placeprotectiveplasticsealantsonteeth,straighten teeth,
and repair fractured teeth. They also perform curative surgery on gums and supporting bones
to treat gum diseases.
ThedentalclinicissmallinsizeandhasnobranchesinotherregionsofSomaliland,onlyone dentist Dr.
Dr Remadan which is also the owner, work the clinic and two of his assistants.
Thedentalclinicworks11/5everydayexceptweekends,thedentistworktwo shifts.
In the morning the dentist check patients that has already examined and described their
problem,whileintheafternoonthedentisttriestoreceiveandseethecomplaintsofatleast 50 patient.
ApartfromDrRemadanDentalClinic,therearemanyotherdentalclinicswhichprovidethe same
service to the society, but the reliable knowledge of Dr.Abokor and his team made the clinic
the most famous and customer oriented dental clinic in Somaliland.
Page3
