Database Design for Clinic Management System

A Database Design for Clinic Management System is the final requirements in Database management system 1 subject. The system for this database design will be created using JAVA NETBEANS IDE. Clinic Management System is the one who can manage all the records of the check-up, patients, treatments, medicines, and equipment. And the main purpose of Clinic Management System is to maintain the details of the patients and make data retrieval easy and efficient.

Entity Relationship Diagram of Clinic Management System

The clinic management System has 5 table, first the check-up table, this table we can manage all the records of all patient in there check up id number,complains,findings the treatment that given to the patient the medicine that given to the patient and the quantity of medicine that take of the patient and also the date when the patient undergo check-up. The second table is the patient’s table, this table we can manage all the information of the patient, the patient id number, first name, last name, patient type, age and address of the patient. The third table is treatments table, this table has two attributes, the treatment_id, and the treatment_type if what type of treatment that have given to the patient.

The fourth table is medicines table, this table contains all the record of the medicines,the medicine id,medicine name,quantity of the medicine if how many stock do you input in one medicine,available quantity if how many available quantity in that medicine,description if for what sickness that medicine, expiry date if what date of the medicine expired and last the requested date if what date do you request for that medicine.

The fifth table is the equipment table, this table contains all the record of the equipment, the equipment table has four attributes first the equip_id or the equipment id, second is equip_name or equipment name, third is requested_date and last the date defected of the equipment.

 

Features:

• Manage patients
• Manage check-up
• Manage Treatments
• Manage medicines
• Manage equipment
• Medicines Inventory

This database design is designed by  Reyes Suarez Jude

Data Dictionaries:

 Table1: check_up

FIELD NAME	DESCRIPTION	TYPE	LENGTH
check_id	Check-up id number	INT	11
patient_id	Patient id number	INT	11
complains	Complains of the patient	TEXT
findings	finding of patient	TEXT
treat_id	Treatment id number	INT	11
med_id	Medicine id number	INT	11
quantity	Quantity of medicine	INT	11
date	Date of check-up	DATE

 

Table2: patients

FIELD NAME	DESCRIPTION	TYPE	LENGTH
patient_id	Patient id number	INT	11
fname	First name of patient	VARCHAR	64
lname	Last name of patient	VARCHAR	64
patient_type	Type of patient	VARCHAR	64
age	Age of patient	INT	2
address	Address of patient	TEXT

                                                                                                 

Table3:treatments

 

FIELD NAME	DESCRIPTION	TYPE	LENGTH
treat_id	Treatment id number	INT	11
treat_type	Type of treatment	VARCHAR	64

 

Table4:medicines

 

FIELD NAME	DESCRIPTION	TYPE	LENGTH
med_id	Medicine id number	INT	11
med_name	Name of medicine	VARCHAR	64
quantity	Quantity of medicine added	INT	11
available_Qty	Available quantity of medicine	INT	11
description	Description of medicine	TEXT
expiry_date	Expiry date of medicine	DATE
requested_date	Requested date of medicine	DATE

 

 Table5:equipments

FIELD NAME	DESCRIPTION	TYPE	LENGTH
equip_id	Equipment id number	INT	11
equip_name	Equipment name	VARCHAR	64
requested_date	Equipment requested date	DATE
date_defected	Equipment date defected	DATE

 

If you have any questions or suggestions, please contact us.