Question: Consider the following database schema. Student ( StudentId, Stud _ Name ) ; Course ( CourseId, Cour _ Name, NoOfPts ) ; Enrolled ( StudentId,

Consider the following database schema.
Student ( StudentId, Stud_Name);
Course ( CourseId, Cour_Name, NoOfPts);
Enrolled ( StudentId, CourseId, Grade);
Retrieve the names of students who have enrolled in the course "Database Systems".
select Stud_name
from Student, Course, Enrolled
where
Student.ID =
Enrolled.ID and Course.coursed= Enrolled.courseid and Cour_name= "Database Systems"
Write a query to count the number of students enrolled in the DBMS-101 course.
Select count(**) from student, enrolled where
student.id =
enrolled.id and coursed="DBMS-101"
Write a query to retrieve all students' student names, enrolled course names, and grades. I want the solution for the last question?
 Consider the following database schema. Student ( StudentId, Stud_Name); Course (

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!