Consider the University Database with the following
relations:
Professors (pid, pname, dept, ext) Students (sid, sname,
major-dept, year)
Courses (cid, cname, dept, credithours)Enrollment (sem-year,
sid, cid, grade)
Teaches (pid, cid, sem-year, class-size),
Professors: All professors have professor id (pid), name
(pname), department that they work (dept), and a phone number
extension for their office (ext). Students: All students have id
(sid), name (sname), department for their major (major-dept), and a
year (yeari.e, freshman, sophomore, junior, etc). Courses: All
courses have...