Developed a database-based Dental Clinic Management System to organize clinic operations and manage patients, staff, appointments, treatments, invoices, and prescriptions.
The system was designed using an ERD and Class Diagram to clearly represent the relationships between the main entities. It includes appointment scheduling, dentist assignment, treatment records, invoice/payment tracking, and prescription management.
Implemented the database structure using SQL with tables, primary keys, foreign keys, and sample data insertion. The project helped improve understanding of database design, relationships, normalization, and system analysis.
