Using the schema:

STUDENT(Sid, Sname, Gender, Age, EntranceYear, GPA)

DEPT(Did, Dname)

PROF(Pid, Pname, Did, Birth_Date)

COURSE(Cno, Did, Cname)

SECTION(Sectno, Did, Cno, Pid)

ENROLL(Eid, Sid, Cno, Sectno, Grade)

Which of the following SQL queries correctly show department IDs and course names?
(Select all that apply)

Question

Using the schema:

STUDENT(Sid, Sname, Gender, Age, EntranceYear, GPA)

DEPT(Did, Dname)

PROF(Pid, Pname, Did, Birth_Date)

COURSE(Cno, Did, Cname)

SECTION(Sectno, Did, Cno, Pid)

ENROLL(Eid, Sid, Cno, Sectno, Grade)

Which of the following SQL queries correctly show department IDs and course names? 
 (Select all that apply)

Answer

SELECT Dname, Cname   
 FROM COURSE;

Answer

SELECT C.Cname, D.Did   
 FROM COURSE C   
 JOIN DEPT D ON C.Cno = D.Did;

Answer

SELECT D.Did, C.Cname   
 FROM DEPT D   
 JOIN COURSE C ON D.Did = C.Did;

Answer

SELECT Did, Cname   
 FROM COURSE;

Answer

SELECT Did, Cname   
 FROM DEPT   
 GROUP BY Did;

Crowdly