Python Tkinter GUI Mysql

PROGRAM FOR HANDLING A SYSTEM FOR EXAMS TKINTER GUI MUST BE USED + CONNECTION TO MYSQL FOR THE DATABASE The program should be connected to the database (mysql) through: [login to view URL](host='localhost', port=3306, user='Eksamenssjef', passwd='oblig2020', db='oblig2020') The program should be based and designed through the t-kinter and grid (geometry manager). The dates should be registered as <year-month-day>, example. 20190510 for 10.05.2019. New students that are registered should be numbered. BUT autoincrement should NOT be used in the database. an exam in one/specific subject can be completed only in ONE room. THE DATABASE PART Table Structure of the Database - The database is called 'oblig2020': Student(Studentnr, FirstName, Surname, Email, PhoneNumber) Subject (SubjectCode, Subjectname, Points) Room (Roomnr, NumberofPlaces) Exam (SubjectCode*, Date, Roomnr*) ExamResult (Studentnr*, SubjectCode*, Date*, Grade) Studentnr CHAR(6) FirstName CHAR(30) SurnameCHAR(20) Email CHAR(40) PhoneNumber CHAR(8) SubjectCode CHAR(8) SubjectNameCHAR(40) Points DECIMAL(3,1) Roomnr CHAR(4) NumberofPlaces INTEGER(3) Date DATE Grade CHAR(1) THE TASK OF THE PROGRAM The application should be able to add, update, and delete students, exam, and examresults. Furthermore the application should be able to: add, update and delete future exams and be able to control that one room is set up for ONLY one exam per day. print out/show all exams on a particular day, with information of subject and room. print out/show all exams in a particular period, ordered after DATE with information on which subject and room. Register a grade for an exam that took place. print out/show all EXAMRESULTS in a subject ("grade list"), in other words a list of students with grades that are ordered by student number. print out/show grade statistics for a completed exam in a subject with all the subject information and a count of how many candidates got which grade on the exam. print out/show all EXAMRESULTS with subjectname and how many points that each student has(with that a student can have one or more examresults in one particular subject), ordered by an exam date.