dental software
DESCRIPTION
This ppt you will to some help for ppt presentation and Don't be forget thanks Mitesh Patel project4free.blogspot.comTRANSCRIPT
Presented By: Mitesh PatelProject4free.blogspot.com
Dental Software
Kadi Sarva Vishwavidyalaya (2009)Sector -15, Gandhinagar.
Project Guide:Maulik Sir
Lecturer M.Sc.(I.T.)
1
2
Project Profile
Project Description
3
Project Title : Dentist System
Front- End : Microsoft Visual Studio 2005(VB.NET)
Back- End : SQL Server 2000
Team Size : 2 Students
Role : Analysis, Design, Coding & Testing.
Developed By : Kena Patel 0810IT106
Khushabu Shah 0810IT168
Project Guide : Prof. Maulik Sir
4
Project Defination
Definition & FunctionalityWe create DENTAL SOFTWARE, which is useful for
dentist who has their own clinic, and busy in their day-to-day life & work.
In this field there are many problem which are face by
dentist such as maintain the records of patients, preserving that record for future use, to get the particular records where needed.
Considering this problems we design a dental software which is useful to doctors not only to maintain the records of patient, reserving the record of patients, get the particular record but also there are so many other utilities which including in this project such as appointment scheduling, library, reference doctor details and other utilities.
5
Data Flow Diagram
6
Modules of System
DentistSystem
PatientHistory
Ref. Dr.List
AppointmentScheduling
PaymentList
Billing Information
DiseaseInformation
7
Context Level Diagram
DENTALSYSTEM
Doctor
Ref.Doctor
Compounder
Patient
Payment ofCommision
Fill DiseaseInformation
Give NextAppointment
Ref. Dr. Information
Give Informationabout timescheduling
Insert & updateAppointment detail
Generate Bill
Give generaldetail
Payment
8
Scheduling Process(1st Level)
SchedulingProcess
Patient Doctor
Compounder
Check & UpdateFor Appointment
AppointmentDetails
Appointmentdate
Give theAppointment details
Patients nextappointment
TblAppointment
9
Disease Information(2nd Level)
Doctor
DiseaseChecking
CheckingTreatment
Reasons forDisease
Give the DiseaseInformation Treatment for
Disease
Give thereasons
Patient
Give thedetailsabout
Treatment
TblDisease10
System Flow Diagram
Login
Logof
Logof
Doctor
Compounder
Give new appointment
ChooseRef. Dr.
ChooseDisease
ModifyRecord
CalculateCommision
ChooseTreatment
FillSymptoms
SelectPrognoses
PatientInformation
Ref. Dr.Information
AppointmentSchedule
PatientInformation
ModifyRecord
PatientPayment info
AppointmentSchedule
Ref. Dr.Billing Info.
11
Database Model Diagram
12
Database Model Diagram
13
Entity Relationship Diagram
14
Determines
Symptoms
Disease Determines
Sufferfrom Treatment
To doPatient
Uses
A
15
Entity Relationship Diagram
A
Take
Paid
Appointment
Fees
Commision
Ref. Doctor
16
Data Dictionary
17
Patient Detail Table NO. FIELD NAME DATA
TYPEFIELD SIZE DE SCRIPTION Allow
Null
1 PatientID numeric 9 Number of patient (PK)
2 FirstName varchar 15 First name of patient
3 MiddleName varchar 15 Middle name of patient
4 LastName varchar 20 Last name of patient
5 BirthDate Varchar 20 Date of birth
6` Occupation Varchar 10 Patient occupation
7 Gender Varchar 1 Male\Female
8 Address Varchar 15 Address of patient
9 Region Varchar 15 Patient region
10 City Varchar 9 Name of patient city
11 PhoneNoR Numeric 11 Residence phone no
12 PhoneNoO Numeric 11 Office phone no
13 MobileNo Numeric 10 Mobile no
14 E-mailID Varchar 30 E-mail of patient
18
Patient Disease Detail Table
NO. FIELD NAME DATATYPE
FIELD SIZE DESCRIPTION Allow Null
1 PatientID Numeric 9 Number of patient (FK)
2 FirstName Varchar 15 First name of patient
3 Fees Money 8 Patient checking fees
4 DiseaseName Varchar 20 Name from which patient suffer
5 Symp1 Varchar 50 First symptoms of disease
6 Symp2 Varchar 50 Second symptoms of disease
7 Symp3 Varchar 50 Third symptoms of disease
8 Symp4 Varchar 50 Four symptoms of disease
9 Treat1 Varchar 50 First treatment of disease
10 Treat2 Varchar 50 Second treatment of disease
11 Treat3 Varchar 50 Third treatment of disease
12 Treat4 Varchar 50 Four treatment of disease
13 Effect Varchar 10 Effect of treatment
14 DoctorID Varchar 9 Doctor ID if related (FK)
15 RefDrName Varchar 15 Name of doctor
19
Reference Doctor Detail Table
NO. FIELD NAME DATATYPE
FIELD SIZE DESCRIPTION Allow Null
1 DoctorID Numeric 9 Number of doctor (PK)
2 Name Varchar 15 First name of doctor
3 AddressR Varchar 50 Address of Reference doctor
4 RegionR Varchar 15 Region of residences
5 CityR Varchar 15 City of residences
6 AddressC Varchar 50 Address of clinic
7 RegionC Varchar 15 Region of clinic
8 CityC Varchar 15 City of clinic
9 PhoneNoR Numeric 11 Residences phone no
10 PhoneNoC Numeric 11 Clinic phone no
11 MobileNo Numeric 10 Mobile no of reference doctor
12 Rate Float 8 Rate of commission
13 Category Numeric 20 Fields of doctors
14 EmailID Varchar 20 Email address of Ref. Doctor 20
Payment of Patient TableNO. FIELD NAME DATA
TYPEFIELD SIZE
DESCRIPTION Allow Null
1 BillNo Numeric 9 Bill no (PK)
2 PatientID Numeric 9 Number of patient (FK)
3 FirstName Varchar 15 First name of patient
4 TotalAmount Money 8 Total paid amount
5 PaidAmount Money 8 Amount which is paid
6 Remaining Money 8 Remaining amount
7 PaymentType Varchar 10 Cash/Cheque
8 ChequeNo Numeric 10 Cheque no
9 AccountNo Numeric 16 Account no
10 BankName Varchar 30 Bank name
21
Billing of Reference Doctor Table
NO. FIELD NAME DATATYPE
FIELD SIZE DESCRIPTION Allow Null
1 BillNo Numeric 9 Bill no (FK)
2 DoctorID Numeric 9 Number of doctor (FK)
3 Name Varchar 15 First name of doctor
4 TotalAmt Money 8 Total paid amount
5 PaidAmt Money 8 Amount which is paid
6 Remaining Money 8 Remaining amount
7 PaymentType Varchar 10 Cash/Cheque
8 ChequeNo Numeric 10 Cheque no
9 AccountNo Numeric 16 Account no
10 BankName Varchar 30 Bank name
22
Appointment Detail Table
NO. FIELD NAME DATATYPE
FIELD SIZE
DESCRIPTION Allow Null
1 Appointment Numeric 9 Appointment number (PK)
2 PatientID Numeric 9 Number of patient (FK)
3 FirstName Varchar 15 Name of patient
4 [Date] Varchar 20 Date when appointment fixed
5 [Time] Varchar 20 Time of appointment
23
Login Table
NO. FIELD NAME DATATYPE
FIELD SIZE
DESCRIPTION Allow Null
1 Category Varchar 10 Doctor/Compounder
2 Username Varchar 15 User name
3 Password Varchar 10 Password which open system
4 Hints Varchar 25 Hints related password
24
Screen Layouts
25
Splash Screen
26
Login Form
27
28
Validation on Login Form
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
Crystal Reports
53
54
55
56
57
58
59
60
61
62
63
64
Thank You
65