Suppose the following tables are part of a university database system, where key

Question

Suppose the following tables are part of a university database system, where keys are underlined: Professor(ssn, profname, status) stores the information of professors, Course(crscode, crsname, credits) stores the information of courses, and Taughe). e)Write an SQL query to return the courses that have been taught in all semesters.
f). Write an SQL query to return the courses that have been taught only by junior professors.
g). Write an SQL query to return the professors who taught the most number of courses in Fall 2001.
h). Define an SQL view TaughtNum that gives the number of courses each profess teaches in each semester.
i). Write an SQL CREATE ASSERTION statement to force the constraint “one professor cannot teach the same course in two contiguous semesters”.
j). Write an SQL CREATE TRIGGER statement to force the constraint “one professor cannot teach the same course in two contiguous semesters”.t(crscode, ssn, semester) stores the information of teaching history.

Explanation / Answer

Hi I have done the solution for this in my laptop. But due to no time, I cannot type it here.. So please rate me Lifesaver and I'll share the answer with you through email or cramster inbox. I don't do this generally, but I have no other option here because there's very less time remaining... you need not worry as I have the solution ready

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.