For those departments that have no majors taking a College Geometry course, prin

Question

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. 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) Here is the create table data CREATE TABLE student ( sid INTEGER, sname VARCHAR, sex CHAR(1), age INTEGER, gpa REAL, PRIMARY KEY (sid) ); CREATE TABLE dept ( dname VARCHAR, numphds INTEGER, PRIMARY KEY (dname) ); CREATE TABLE prof ( pname VARCHAR, dname VARCHAR, PRIMARY KEY (pname), FOREIGN KEY (dname) REFERENCES dept ); CREATE TABLE course ( cno INTEGER, cname VARCHAR, dname VARCHAR, PRIMARY KEY (cno, dname), FOREIGN KEY (dname) REFERENCES dept ); CREATE TABLE major ( dname VARCHAR, sid INTEGER, PRIMARY KEY (dname, sid), FOREIGN KEY (dname) REFERENCES dept, FOREIGN KEY (sid) REFERENCES student ); CREATE TABLE section ( dname VARCHAR, cno INTEGER, sectno INTEGER, pname VARCHAR, PRIMARY KEY (dname, cno, sectno), FOREIGN KEY (dname) REFERENCES dept, FOREIGN KEY (cno, dname) REFERENCES course, FOREIGN KEY (pname) REFERENCES prof ); CREATE TABLE enroll ( sid INTEGER, grade CHAR(1), dname VARCHAR, cno INTEGER, sectno INTEGER, PRIMARY KEY (sid, dname, cno, sectno), FOREIGN KEY (sid) REFERENCES student, FOREIGN KEY (dname) REFERENCES dept, FOREIGN KEY (cno, dname) REFERENCES course, FOREIGN KEY (dname, cno, sectno) REFERENCES section ); Here is some of the inserts that go with said table. just as an example. Insert into Student(sid,sname,sex,age,year,gpa) values('10', 'Jones, David S.', 'm', '19', '2', '3.50') Insert into Student(sid,sname,sex,age,year,gpa) values('11', 'Paul, Mary W.', 'f', '23', '5', '3.60') Insert into Student(sid,sname,sex,age,year,gpa) values('12', 'Soong, V.', 'f', '24', '5', '3.50') Insert into Student(sid,sname,sex,age,year,gpa) values('13', 'Kellerman, S.', 'f', '21', '3', '2.90') Insert into Student(sid,sname,sex,age,year,gpa) values('14', 'Cheong, R.', 'm', '24', '5', '3.00') Insert into Student(sid,sname,sex,age,year,gpa) values('15', 'Borchart, Sandra L.', 'f', '26', '5', '3.90') Insert into Student(sid,sname,sex,age,year,gpa) values('16', 'Alsberg, David J.', 'm', '25', '5', '3.50')

Explanation / Answer

please check your question again ,it is too difficult to understand as there is all over statement ,please re post the question with clear and correction

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

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