Database Management System

A derma clinic provides appointment to its patients. The following table provides a record of appointment for surgical procedures.

Doctor ID Doctor Name Patient Number Patient Name Appointmen Date Surgery Number Surgery Name D1011 Jan Anthony P100 John 6/1/2020 Biopsy D1011 Jan Anthony P110 Justin 6/12/2020 53 Photodynamic therapy D1025 Mark P105 Rick 6/7/2020 52 Warts removal D1025 Mark P105 Rick 6/23/2020 54 Grafting D1035 Rupert P110 Ella 6/28/2020 55 Cryotherapy