{"repo":"CSI2532-Databases-I-Group-8/Dental-Clinic-Management-System","free":true,"listed":false,"github":"https://github.com/CSI2532-Databases-I-Group-8/Dental-Clinic-Management-System","clone":"git clone https://github.com/CSI2532-Databases-I-Group-8/Dental-Clinic-Management-System.git","description":"Dental Clinic Management System (DCMS) for a dental centre with clinics in major cities across Canada using PHP and PostgreSQL.","language":"PHP","stars":17,"topics":["postgresql","backend","database-management","frontend","php"],"license":null,"category":"databases-storage","readme_excerpt":"Overview - Dental clinic functional website: https://dental-clinic-management-system-n0em.onrender.com/index.php - Database link: https://console.neon.tech/app/projects/round-butterfly-70109006/branches/br-patient-tooth-a4gpouvi/tables?database=neondb - Demo video (en français): https://www.youtube.com/watch?v=8031YFqOKfg Login ID: hygienist: akiti7935 dentist: cwmk3565 patient: randommd5 receptionist: bobmley1 Password for all existing accounts above: ASDFGHJKL:123456 This Dental Clinic Management System (DCMS) provides an efficient and fast way to manage appointments and related activities for a dental center with clinics in major cities across Canada. In addition, this DCMS will enable the dental center practitioners to track records, minimize data loss, provide privacy & security of records, enable quick report generation, implement updates, eliminate redundant paper work, and save time. Implementation All components of this application are implemented from scratch which includes the ER model, the relational schema, populated relations, database queries, as well as the user interface. The DCMS is hosted on Heroku. Database Structure User Types - Administrator - The administrator can create, view, edit, or delete all information within the system. - Employee - Details of the treatment rendered must be recorded in the patient’s chart progress notes by an employee. - Every employee needs to be identified by some basic information (e.g. given names, address, role, employee ty","default_branch":null,"files":null,"tree":[],"storefront":"/r/CSI2532-Databases-I-Group-8","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/CSI2532-Databases-I-Group-8/Dental-Clinic-Management-System/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}