For those departments that have no majors taking


Here are the tables. 

Student(sid,sname,sex,age,year,qpa) 
Dept(dname,numphds) 
Prof (pname,dname) 
Course (cno,cname,dname) 
Major(dname,sid) 
Section(dname,cno,sectno,pname) 
Enroll(sid,grade,dname,cno,sectno)

For those departments that have no majors taking a College Geometry course, print the department name and the number of PhD students in the department.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: For those departments that have no majors taking
Reference No:- TGS097190

Expected delivery within 24 Hours