Write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If you cannot capture some constraints, explain why. A university database contains information about professors (identified by social security number, or SSN) and courses (identified by courseid). Professors teach courses; each of the following situations concerns the Teaches relationship set.

a. Professors can teach the same course in several semesters, and each offering must be recorded.

b. Professors can teach the same course in several semesters, and only the most recent such offering needs to be recorded. (Assume this condition applies in all subsequent questions.)

c. Every professor must teach some course. d. Every professor teaches exactly one course (no more, no less).

e. Every professor teaches exactly one course (no more, no less), and every course must be taught by some professor.

please dont draw the ER diagram write the SQL statement for the cases to create the corresponding relations and capture as many of the constraints as possible. If you cannot capture some constraints, explain why.