Question: Consider the following database schema. Student ( StudentId, Stud _ Name ) ; Course ( CourseId, Cour _ Name, NoOfPts ) ; Enrolled ( StudentId,
Consider the following database schema.
Student StudentId, StudName;
Course CourseId, CourName, NoOfPts;
Enrolled StudentId, CourseId, Grade;
Retrieve the names of students who have enrolled in the course "Database Systems".
select Studname
from Student, Course, Enrolled
where
Student.ID
Enrolled.ID and Course.coursed Enrolled.courseid and Courname "Database Systems"
Write a query to count the number of students enrolled in the DBMS course.
Select count from student, enrolled where
student.id
enrolled.id and coursedDBMS
Write a query to retrieve all students' student names, enrolled course names, and grades. I want the solution for the last question?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
