Base on this three relations, choose the right SQL sentences to answer the following queries. Students (SID, name) Courses (CID, name, credit) Enrollments (SID, CID, score) The Students relation gives...


Base on this three relations, choose the right SQL sentences to answer the<br>following queries.<br>Students (SID, name)<br>Courses (CID, name, credit)<br>Enrollments (SID, CID, score)<br>The Students relation gives the ID and name gender of each student. The Courses<br>relation gives the ID, name and credit of each course. The Enrollments relation<br>gives the score of each student in each course. SID is the ID of student, and CID is<br>the ID of course. The primary key of each relation is underlined.<br>Find the scores of all students in the course

Extracted text: Base on this three relations, choose the right SQL sentences to answer the following queries. Students (SID, name) Courses (CID, name, credit) Enrollments (SID, CID, score) The Students relation gives the ID and name gender of each student. The Courses relation gives the ID, name and credit of each course. The Enrollments relation gives the score of each student in each course. SID is the ID of student, and CID is the ID of course. The primary key of each relation is underlined. Find the scores of all students in the course "Database Systems". (There are several courses named "Database Systems".) O A SELECT score FROM Enrollments, Courses WHERE name="Database Systems"; OB SELECT score FROM Enrollments e, Courses c WHERE name="Database Systems" and e.CID=c.CID ; OC SELECT score FROM Enrollments WHERE CID = (SELECT CID FROM Courses WHERE name="Database Systems"); OD SELECT score FROM Enrollments WHERE CID IN (SELECT CID FROM Courses WHERE name="Database Systems");

Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here