Implement a University Registration System in Java or python using JDBC $($or you can use other programming Implement a University Registration System in Java using JDBC $($or you can use other programming

languages and$/$or ODBC$).$

Database users:

Staff: These users can add and delete courses and students, and register and drop courses for

students. At the end of the semester, grades should be uploaded.

The database schema is given in the file createtables.sql$.$

The following real$-$world constraints need to be enforced by your program:

Students cannot register for a class twice for the same year and semester.

If a course is deleted, all registrations of that course need to be deleted too. $($delete from

registration table first, then delete it from the course table.$)$

If a student is deleted from the system, all registrations of that student need to be deleted too.

$($delete from registration table first, then delete it from the student table.$)$

The Java application will be a terminal$-$based program that has the following interactions with the users.

If you use GUI, you should have same menu options.

Menu:

$***$ Welcome to Online Registration System $***$Add a course

Delete a course

Add a student

Delete a student

Register a course $($optional$)$

Check student registration

Upload grades $($optional$)$

Quit

Note:

Delete a course by giving a course code

Delete a student by giving a student SSN

Check a student's registration by giving a student SSN$,$ then list all courses that student registered $($show

all courses' code, year, and semester$)$

Register a course and Upload Grades functions are not required to implement. If you have

enough time, it is a good practice to finish all functions.

Upload grades by giving code, year, semester $($then ask the user the grade for every student who registers

the course and save it in the table$)$

Your application needs to be user friendly.

languages and$/$or ODBC$).$

Database users:

Staff: These users can add and delete courses and students, and register and drop courses for

students. At the end of the semester, grades should be uploaded.

The database schema is given in the file createtables.sql$.$

The following real$-$world constraints need to be enforced by your program:

Students cannot register for a class twice for the same year and semester.

If a course is deleted, all registrations of that course need to be deleted too. $($delete from

registration table first, then delete it from the course table.$)$

If a student is deleted from the system, all registrations of that student need to be deleted too.

$($delete from registration table first, then delete it from the student table.$)$

The Java application will be a terminal$-$based program that has the following interactions with the users.

If you use GUI, you should have same menu options.

Menu:

$***$ Welcome to Online Registration System $***$Add a course

Delete a course

Add a student

Delete a student

Register a course $($optional$)$

Check student registration

Upload grades $($optional$)$

Quit

Note:

Delete a course by giving a course code

Delete a student by giving a student SSN

Check a student's registration by giving a student SSN$,$ then list all courses that student registered $($show

all courses' code, year, and semester$)$

Register a course and Upload Grades functions are not required to implement. If you have

enough time, it is a good practice to finish all functions.

Upload grades by giving code, year, semester $($then ask the user the grade for every student who registers

the course and save it in the table$)$

Your application needs to be user friendly.

the picture attached is createtables.sql schema