Make relational schema or mapping for the followingCREATE DATABASE myDB; $///////////////////////////////////////////$USE myDB;$///////////////////////////////////////////$CREATE TABLE Department $($ Department$\_$ID INT PRIMARY KEY, Department$\_$Name VARCHAR$(100),$ Department$\_$Head INT$)$;$///////////////////////////////////////////$CREATE TABLE Professor $($ Professor$\_$ID INT PRIMARY KEY, Name VARCHAR$(100),$ Specialization VARCHAR$(100))$;$///////////////////////////////////////////$CREATE TABLE Subject $($ Subject$\_$ID INT PRIMARY KEY, Name VARCHAR$(100))$;$///////////////////////////////////////////$CREATE TABLE Student $($ Student$\_$ID INT PRIMARY KEY, Name VARCHAR$(100),$ Major VARCHAR$(100))$;$///////////////////////////////////////////$CREATE TABLE Grade $($ Grade$\_$ID INT PRIMARY KEY, Grade$\_$Name VARCHAR$(10))$;$///////////////////////////////////////////$CREATE TABLE Course $($ Course$\_$ID INT PRIMARY KEY, Course$\_$Name VARCHAR$(100),$ Credit$\_$Hours INT, Department$\_$ID INT, FOREIGN KEY $($Department$\_$ID$)$ REFERENCES Department$($Department$\_$ID$))$;$///////////////////////////////////////////$CREATE TABLE Enrollment $($ Enrollment$\_$ID INT PRIMARY KEY, Student$\_$ID INT, Course$\_$ID INT, Enrollment$\_$Date DATE, FOREIGN KEY $($Student$\_$ID$)$ REFERENCES Student$($Student$\_$ID$),$ FOREIGN KEY $($Course$\_$ID$)$ REFERENCES Course$($Course$\_$ID$))$;$///////////////////////////////////////////$CREATE TABLE Transcript $($ Transcript$\_$ID INT PRIMARY KEY, Student$\_$ID INT, Course$\_$ID INT, Grade$\_$ID INT, FOREIGN KEY $($Student$\_$ID$)$ REFERENCES Student$($Student$\_$ID$),$ FOREIGN KEY $($Course$\_$ID$)$ REFERENCES Course$($Course$\_$ID$),$ FOREIGN KEY $($Grade$\_$ID$)$ REFERENCES Grade$($Grade$\_$ID$))$;$///////////////////////////////////////////$CREATE TABLE Teach $($ Professor$\_$ID INT, Subject$\_$ID INT, PRIMARY KEY $($Professor$\_$ID$,$ Subject$\_$ID$),$ FOREIGN KEY $($Professor$\_$ID$)$ REFERENCES Professor$($Professor$\_$ID$),$ FOREIGN KEY $($Subject$\_$ID$)$ REFERENCES Subject$($Subject$\_$ID$))$;$///////////////////////////////////////////$CREATE TABLE Advises $($ Professor$\_$ID INT, Student$\_$ID INT, PRIMARY KEY $($Professor$\_$ID$,$ Student$\_$ID$),$ FOREIGN KEY $($Professor$\_$ID$)$ REFERENCES Professor$($Professor$\_$ID$),$ FOREIGN KEY $($Student$\_$ID$)$ REFERENCES Student$($Student$\_$ID$))$;$///////////////////////////////////////////$CREATE TABLE Manages $($ Professor$\_$ID INT, Department$\_$ID INT, PRIMARY KEY $($Professor$\_$ID$,$ Department$\_$ID$),$ FOREIGN KEY $($Professor$\_$ID$)$ REFERENCES Professor$($Professor$\_$ID$),$ FOREIGN KEY $($Department$\_$ID$)$ REFERENCES Department$($Department$\_$ID$))$;$///////////////////////////////////////////$CREATE TABLE Offers $($ Department$\_$ID INT, Course$\_$ID INT, PRIMARY KEY $($Department$\_$ID$,$ Course$\_$ID$),$ FOREIGN KEY $($Department$\_$ID$)$ REFERENCES Department$($Department$\_$ID$),$ FOREIGN KEY $($Course$\_$ID$)$ REFERENCES Course$($Course$\_$ID$))$;$///////////////////////////////////////////$CREATE TABLE Enroll $($ Student$\_$ID INT, Subject$\_$ID INT, Enrollment$\_$Date DATE, PRIMARY KEY $($Student$\_$ID$,$ Subject$\_$ID$),$ FOREIGN KEY $($Student$\_$ID$)$ REFERENCES Student$($Student$\_$ID$),$ FOREIGN KEY $($Subject$\_$ID$)$ REFERENCES Subject$($Subject$\_$ID$))$;$///////////////////////////////////////////$CREATE TABLE Prerequisite $($ Course$\_$ID INT, Prerequisite$\_$Course$\_$ID INT, PRIMARY KEY $($Course$\_$ID$,$ Prerequisite$\_$Course$\_$ID$),$ FOREIGN KEY $($Course$\_$ID$)$ REFERENCES Course$($Course$\_$ID$),$ FOREIGN KEY $($Prerequisite$\_$Course$\_$ID$)$ REFERENCES Course$($Course$\_$ID$))$;$///////////////////////////////////////////$CREATE TABLE Belongs $($ Student$\_$ID INT, Department$\_$ID INT, PRIMARY KEY $($Student$\_$ID$,$ Department$\_$ID$),$ FOREIGN KEY $($Student$\_$ID$)$ REFERENCES Student$($Student$\_$ID$),$ FOREIGN KEY $($Department$\_$ID$)$ REFERENCES Department$($Department$\_$ID$))$;$///////////////////////////////////////////$ALTER TABLE DepartmentADD CONSTRAINT FK$\_$Department$\_$Head FOREIGN KEY $($Department$\_$Head$)$ REFERENCES Professor$($Professor$\_$ID$)$;$///////////////////////////////////////////--$INSERT$--///////////////////////////////////////////$INSERT INTO Professor $($Professor$\_$ID$,$ Name, Specialization$)$ VALUES $(1,$ 'Mohammed Khalid', 'Medicine'$),(2,$ 'Mattar Ebrahim', 'Astrophysics'$),(3,$ 'Abdullah Nabil', 'Marketing'$),(4,$ 'Ghadeer Mohammed', 'Accounting'$),(5,$ 'Hanan Taqi', 'Cyber Security'$),(6,$ 'Khalil Ebrahim', 'Electrical Engineering'$),(7,$ 'Oliver Fariel', 'Surgery'$),(8,$ 'Usman Ahmed', 'Applied Math'$),(9,$ 'Mohamed Wahed', 'Data Science'$),(10,$ 'Eman Ali', 'Civil Engineering'$)$;$///////////////////////////////////////////$INSERT INTO Department $($Department$\_$ID$,$ Department$\_$Name, Department$\_$Head$)$ VALUES $(1,$ 'Business and Law', $3),(2,$ 'Health Sciences', $7),(3,$ 'Engineering', $10),(4,$ 'Science', $2),(5,$ 'Technology', $5)$;$///////////////////////////////////////////$INSERT INTO Subject $($Subject$\_$ID$,$ Name$)$ VALUES $(1,$ 'Discrete Math'$),(2,$ 'Operating Systems'$),(3,$ 'Calculus'$),(4,$ 'Physics'$),(5,$ 'Signals and systems'$),(6,$ 'Dynamics'$),(7,$ 'Radio Diagnosis'$),(8,$ 'Anatomy'$),(9,$ 'Marketing'$),(10,$ 'Accounting'$)$;