Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Harness The Power Of Big Data The IBM Big Data Platform

Authors: Paul Zikopoulos, David Corrigan James Giles Thomas Deutsch Krishnan Parasuraman Dirk DeRoos Paul Zikopoulos

1st Edition

0071808183, 9780071808187

More Books

Students also viewed these Databases questions