USE student$\_$registration$\_$system;

CREATE TABLE departments $($

department$\_$id INT PRIMARY KEY AUTO$\_$INCREMENT,

department$\_$name VARCHAR$(100)$

$)$;

CREATE TABLE students $($

student$\_$id INT PRIMARY KEY AUTO$\_$INCREMENT,

first$\_$name VARCHAR$(100),$

last$\_$name VARCHAR$(100),$

department$\_$id INT,

FOREIGN KEY $($department$\_$id$)$ REFERENCES departments$($department$\_$id$)$

$)$; CREATE TABLE courses $($

course$\_$id INT PRIMARY KEY AUTO$\_$INCREMENT,

course$\_$name VARCHAR$(100)$

$)$;

CREATE TABLE registrations $($

registration$\_$id INT PRIMARY KEY AUTO$\_$INCREMENT,

student$\_$id INT,

course$\_$id INT,

registration$\_$date DATE,

FOREIGN KEY $($student$\_$id$)$ REFERENCES students$($student$\_$id$),$

FOREIGN KEY $($course$\_$id$)$ REFERENCES courses$($course$\_$id$)$

$)$; BASED ON THE RELATION DATABASE PROVIDED ABOVE, CREATE CODES FOR STUDENT REGISTRATION SYSTEM THAT WILL CREATE A GUI USING THE BELLOW INFORMATION. GIVE COMPLETE CODES AND ALSO GIVE COMPLETE CODES FOR INSERT,DELETE,UPDATE AND GET FUNCTIONS. Give correct codes for each step and DESCRIBE THE FUNCTIONALITY. NOTE: USE Python and MySQL workbeanch my$\_$cursor $=$ mydb$.$cursor$()$

def insert$()$:

first$\_$name $=$ e$\_$first$\_$name.get$()$

last$\_$name $=$ e$\_$last$\_$name.get$()$

department$\_$id $=$ e$\_$department$\_$id$.$get$()$

if first$\_$name $==""$ or last$\_$name $==""$ or department$\_$id $==""$:

messagebox.showinfo$("$Insert status", "All fields are required"$)$

else:

my$\_$cursor.execute$("$INSERT INTO students $($first$\_$name, last$\_$name, department$\_$id$)$ VALUES $(\%$s$,\%$s$,\%$s$)",$

$($first$\_$name, last$\_$name, department$\_$id$))$

mydb$.$commit$()$

e$\_$first$\_$name.delete$(0,$ 'end'$)$

e$\_$last$\_$name.delete$(0,$ 'end'$)$

e$\_$department$\_$id$.$delete$(0,$ 'end'$)$

messagebox.showinfo$("$Insert status", "Insert successful"$)$

def delete$()$:

student$\_$id$\_$to$\_$delete $=$ get$\_$student$\_$id$()$

if student$\_$id$\_$to$\_$delete is not None:

my$\_$cursor.execute$("$DELETE FROM students WHERE student$\_$id $=\%$s$",($student$\_$id$\_$to$\_$delete,$))$

mydb$.$commit$()$

messagebox.showinfo$("$Delete status", "Deletion successful"$)$

def update$()$:

student$\_$id$\_$to$\_$update $=$ get$\_$student$\_$id$()$

if student$\_$id$\_$to$\_$update is not None:

first$\_$name $=$ e$\_$first$\_$name.get$()$

last$\_$name $=$ e$\_$last$\_$name.get$()$

department$\_$id $=$ e$\_$department$\_$id$.$get$()$

my$\_$cursor.execute$("$UPDATE students SET first$\_$name$=\%$s$,$ last$\_$name$=\%$s$,$ department$\_$id$=\%$s WHERE student$\_$id$=\%$s$",$

$($first$\_$name, last$\_$name, department$\_$id$,$ student$\_$id$\_$to$\_$update$))$

mydb$.$commit$()$

messagebox.showinfo$("$Update status", "Update successful"$)$

def get$()$:

student$\_$id$\_$to$\_$fetch $=$ get$\_$student$\_$id$()$

if student$\_$id$\_$to$\_$fetch is not None:

my$\_$cursor.execute$("$SELECT $*$ FROM students WHERE student$\_$id $=\%$s$",($student$\_$id$\_$to$\_$fetch,$))$

rows $=$ my$\_$cursor.fetchall$()$

for row in rows:

e$\_$first$\_$name.insert$(0,$ row$[1])$

e$\_$last$\_$name.insert$(0,$ row$[2])$

e$\_$department$\_$id$.$insert$(0,$ row$[3])$

messagebox.showinfo$("$Get status", "Fetch successful"$)$

def get$\_$student$\_$id$()$:

student$\_$id $=$ entry$\_$student$\_$id$.$get$()$

return student$\_$id

root $=$ Tk$()$

root.geometry$("900$x$500")$

root.title$("$STUDENT REGISTRATION SYSTEM"$)$

first$\_$name$\_$label $=$ Label$($root$,$ text$=$'First Name', font$=(\text{'}$bold$\text{'},10))$

first$\_$name$\_$label.place$($x$=20,$ y$=60)$

last$\_$name$\_$label $=$ Label$($root$,$ text$=$'Last Name', font$=(\text{'}$bold$\text{'},10))$

last$\_$name$\_$label.place$($x$=20,$ y$=90)$

department$\_$id$\_$label $=$ Label$($root$,$ text$=$'Department ID$\text{'},$ font$=(\text{'}$bold$\text{'},10))$

department$\_$id$\_$label.place$($x$=20,$ y$=120)$

entry$\_$student$\_$id $=$ Entry$()$

entry$\_$student$\_$id$.$place$($x$=180,$ y$=30)$

e$\_$first$\_$name $=$ Entry$()$

e$\_$first$\_$name.place$($x$=180,$ y$=60)$

e$\_$last$\_$name $=$ Entry$()$

e$\_$last$\_$name.place$($x$=180,$ y$=90)$

e$\_$department$\_$id $=$ Entry$()$

e$\_$department$\_$id$.$place$($x$=180,$ y$=120)$

insert$\_$button $=$ Button$($root$,$ text$=$"Insert", font$=("$italic$",10),$ bg$=$"white", command$=$insert$)$

insert$\_$button.place$($x$=20,$ y$=180)$

delete$\_$button $=$ Button$($root$,$ text$=$"Delete", font$=("$italic$",10),$ bg$=$"white", command$=$delete$)$

delete$\_$button.place$($x$=70,$ y$=180)$

update$\_$button $=$ Button$($root$,$ text$=$"Update", font$=("$italic$",10),$ bg$=$"white", command$=$update$)$

update$\_$button.place$($x$=120,$ y$=180)$

get$\_$button $=$ Button$($root$,$ text$=$"Get", font$=("$italic$",10),$ bg$=$"white", command$=$get$)$

get$\_$button.place$($x$=180,$ y$=180)$

root.mainloop$()$