insider the following AUI academic database schema $($Primary keys are bold and underlined$)$:

Student $($StudentID$,$ lastname, firstname, email, major, classification, attempted points, carned$\_$points, earned$\_$credits$)$

Course $($CourseCode$,$ title, description, credits$)$

Class $($Clascode$.$ CourseCode, sectionnumber$,$ starttime, endtime, LecturerID$)$

Enroll $($StudentID$,$ ClassCode grade$)$

Lecturer $($LecturerID$,$ lastname, firstname, email, DeptCode$)$