Identify Tables and AttributesTables and Attributes:DepartmentsDepartmentID $($INT$,$ Primary Key$)$DepartmentCode $($VARCHAR$(10),$ Candidate Key$)$DepartmentName $($VARCHAR$(100))$ProfessorsProfessorID $($INT$,$ Primary Key$)$SSN $($CHAR$(11),$ Candidate Key$)$Email $($VARCHAR$(255),$ Candidate Key$)$FirstName $($VARCHAR$(50))$LastName $($VARCHAR$(50))$HireDate $($DATE$)$DepartmentID $($INT$,$ Foreign Key$)$mlllStudentsStudentID $($INT$,$ Primary Key$)$SSN $($CHAR$(11),$ Candidate Key$)$Email $($VARCHAR$(255),$ Candidate Key$)$FirstName $($VARCHAR$(50))$LastName $($VARCHAR$(50))$DateOfBirth $($DATE$)$CoursesCourseID $($INT$,$ Primary Key$)$CourseCode $($VARCHAR$(10),$ Candidate Key$)$CourseName $($VARCHAR$(100))$Credits $($INT$)$DepartmentID $($INT$,$ Foreign Key$)$EnrollmentsEnrollmentID $($INT$,$ Primary Key$)$StudentID $($INT$,$ Foreign Key$)$CourseID $($INT$,$ Foreign Key$)$EnrollmentDate $($DATE$)$Grade $($CHAR$(2))$UNIQUE $($StudentID$,$ CourseID$)($Composite Candidate Key$)$CourseAssignmentsAssignmentID $($INT$,$ Primary Key$)$CourseID $($INT$,$ Foreign Key$)$ProfessorID $($INT$,$ Foreign Key$)$AssignmentDate $($DATE$)$UNIQUE $($CourseID$,$ ProfessorID$)($Composite Candidate Key$)$