Database Management System - Old Questions

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

teaches(TID, TName, Qualification)

teaches(TID, CID)

course(CID, CName, CCode)

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

(a) Find the names of all teaches who have PhD qualification.

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

(c) Find the total number of courses taught by Ram Prasad.