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.