dspice
Oct 23, 2008, 08:56 AM
I have 7 tables
Student(sid, sname, sex, age, year, gpa)
Dept(dname, numphds)
Prof(pname, dname)
Course(cno, cname, dname)
Major(dname, sid)
Section(dname, cno, sectno, pname)
Enroll(sid, grade, dname, cno, sectno)
I'm trying to print the names of students who are taking both a computer sciences course and mathematics course. How do I link the tables to find info?
Student(sid, sname, sex, age, year, gpa)
Dept(dname, numphds)
Prof(pname, dname)
Course(cno, cname, dname)
Major(dname, sid)
Section(dname, cno, sectno, pname)
Enroll(sid, grade, dname, cno, sectno)
I'm trying to print the names of students who are taking both a computer sciences course and mathematics course. How do I link the tables to find info?