Answered step by step
Verified Expert Solution
Question
1 Approved Answer
student(sid, snane, sex, age, year, gpa) dept (dnane, numphds) prof (pnane, dnane) course( cno, cnane, dname) major(dnane, sid) ection (dnane, cno, sectno, priane) enroll(sid, grade,
student(sid, snane, sex, age, year, gpa) dept (dnane, numphds) prof (pnane, dnane) course( cno, cnane, dname) major(dnane, sid) ection (dnane, cno, sectno, priane) enroll(sid, grade, dnane, cno, sectno) Print the nanes of professors ho work in departments that have tewer than 5 PhD students Print the nane(s) of student(s) with the lowest gpa For each Computer Sciences class, print the cno, sectno, and the average gpa of the students enrolled in the class Print the course names, course numbers and section numbers of all classes with less than six students enrolled in them Print the name(s) and sid(s) of the student (s) enrolled in the most classes Print the nanes of departnents that have ane or more majors who are under 18 years old Print the names and majors of students who are taking one of the College Geonetry courses. (Hint: You'1l need to use the "like" predicate and the string matching character in your query.) For those departments that have no majors taking a College Ceometry course, print the departnent nane and the number of PhD students in the department Print the nanes of students who are taking both a Computer Sciences course and a Mathenatics course For each departnent that has ane or more majors with a EPA under 1.e, print the nane of the departnent and the average GPA of its majars student(sid, snane, sex, age, year, gpa) dept (dnane, numphds) prof (pnane, dnane) course( cno, cnane, dname) major(dnane, sid) ection (dnane, cno, sectno, priane) enroll(sid, grade, dnane, cno, sectno) Print the nanes of professors ho work in departments that have tewer than 5 PhD students Print the nane(s) of student(s) with the lowest gpa For each Computer Sciences class, print the cno, sectno, and the average gpa of the students enrolled in the class Print the course names, course numbers and section numbers of all classes with less than six students enrolled in them Print the name(s) and sid(s) of the student (s) enrolled in the most classes Print the nanes of departnents that have ane or more majors who are under 18 years old Print the names and majors of students who are taking one of the College Geonetry courses. (Hint: You'1l need to use the "like" predicate and the string matching character in your query.) For those departments that have no majors taking a College Ceometry course, print the departnent nane and the number of PhD students in the department Print the nanes of students who are taking both a Computer Sciences course and a Mathenatics course For each departnent that has ane or more majors with a EPA under 1.e, print the nane of the departnent and the average GPA of its majars
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started