DEV Community

Patricia Joanne
Patricia Joanne

Posted on • Originally published at realicejoanne.gitbook.io

Clinic Management Database System Project

Hey I want to tell a few about my Database System Project which I made with my team: Eko, Tasya, and Januar. Today is the deadline of the project LOL.

So basically this project is about Clinic Management System. We can find 9 main menus, there are: biodata menu, patient menu, doctor menu, nurse menu, treatment menu, recipe menu, medicine menu, appointment menu, and department menu. Each menu consists of 2 submenus, there are View Data and Input Data. This clinic management system is a web-based application using PHP, HTML, and CSS in its creation.

In each of the input data pages, the user will be presented a form to input the data, using the DML INSERT function, which is required according to the selected menu, and on the view page there is a responsive table that is easy to understand for the user, which helps in displaying clinic management system data captured using the DML SELECT function. Also in the view data pages, there is a column in the table that is the action column, which contains ‘Edit’ and ‘Delete’. For the Edit menu, the user is given facility to change or update the existing data based on the ID of the data using DML UPDATE function. And for Delete menu, user can delete existing data line, in case happened error or data is not needed anymore using DML DELETE function.

That’s it. You can view the project source codes and reports in my Github repository. Also please watch me and my team’s explanation about the project in this video below.

Clinic Management Database System Project

Please ignore my childish shrilling voice ._.

Top comments (1)

Collapse
 
almexutrim23 profile image
almexutrim

A Clinic Management Database System Project streamlines administrative and medical processes by efficiently managing patient records, appointment scheduling, billing, and inventory. It is designed to enhance accuracy and reduce manual workload, ensuring seamless operations. For instance, implementing this system in an aesthetic clinic Islamabad would allow the clinic to manage client appointments, track treatment histories, and generate invoices effortlessly. This ensures a smoother client experience, boosts operational efficiency, and supports the clinic's commitment to providing top-notch services.