Now, you want to start to modify the simplest database related to course registration.

To track your courses offered at UTC, UTC should have class profiles such as class ID$,$ class

name, credit information, professor information, and semester information such as Fall$24,$

Spr$25,$ Sum$25,$ and Fall$25($You can create a new entity for the semester and year information;

however, in this exam, we do not consider that option$).$ Each class can be offered by multiple

professors. Once the class is offered by UTC, there should be at least one professor who can

teach the class.

Sometimes professors are on their sabbatical; therefore, professors do not necessarily offer

any class each semester. But they can offer multiple classes $($Specifically$,$ UP TO $4$ CLASSES$)$

each semester. UTC also wants to track the professor's name, department, and email of each

professor.

Students must take at least one class. And UTC wants to track student ID$,$ name, email, and

department.

A class will open as long as one student enrolls in this class.

Each professor and student belongs to only one department. And UTC wants to track

department ID$,$ department name, and email.