Database Management System - Old Questions

3. Consider the following database, where primary keys are underlined

student (SID, SName, semester)

studies (SID, CID)

course (CID, CName, CCode)

Construct the following relational algebra and SQL queries for this database.(10)

(a) Find the names of all students in third semester.

(b) Find the names of all courses studied by Ram.

(c) Find the total number of students who study DBMS.