College of Computer Science and Mathematics

Defense of a diploma thesis in the College of Computer Science and Mathematics – Department of Computer Science

Entitled (Excavation of the Patient Database at the College of Dentistry at the University of Mosul)

In continuation of the scientific research movement and the follow-up and presence of the Dean of the Faculty of Computer Science and Mathematics, Prof. Dr. Duha Bashir Abdel Allah

Discussed in the discussion hall of the College of Computer Science and Mathematics at the University of Mosul on – 21 – 7 – 2024

Diploma thesis for the student Marwa Bassem Mustafa and under the supervision of Assistant Professor Dr. Ammar Zahir Yassin

The thesis submitted by the student dealt with the design and implementation of a system for mining student and patient data at the College of Dentistry at the University of Mosul, using the Microsoft SQL Server database management system to design and implement the database system and the WEKA program for database mining, and the Python language was used to program the system interfaces.

The study dealt with the use of the main steps of the database, which included analysis, design and implementation, as well as the process of mining the seven steps, data collection, pre-processing of data, data exploration, data transformation, data modeling, evaluation, and deployment. The database mining process was divided into two parts; the first part is a smart cluster process for students of the Faculty of Dentistry for the fourth and fifth stages on laboratories (i.e. on the number of chairs available for each laboratory) using three famous algorithms (Canopy, K-Means, EM), the second part is the process of classifying patients into four categories according to the type of treatment that each patient needs using three also famous algorithms (SVM, Naïve Bayes, Random Forest) and the Recall and Precision scales were used to evaluate the best algorithm. After applying the system to the real data of the College of Dentistry at the University of Mosul, it was found that the best cluster algorithm is K-Means and the best classification algorithm is Naive Bayes.

The study aims to establish an electronic system for the design, implementation and excavation of the database of students and patients in the College of Dentistry at the University of Mosul.

The discussion committee was chaired by Prof. Dr. Saja Jassim

Dr. Rayan Yusuf Al-Khayyat Member

Assoc. Prof. Ammar Dahir Yassin Member and Supervisor