X


Tuple Relational Calculus




Q. Find the ID, name, dept name, salary for instructors whose salary is greater than $80,000.



Q. Find the instructor ID for each instructor with a salary greater than $80,000 [ Hint : instructor ( ID, name, dept_name, salary ) ]



Q. Find the names of all instructors whose department is in the Watson building. [ Hint : instructor ( ID, name, dept_name, salary ) and department ( dept_name, building, budget)]



Q. To find the set of all courses taught in the Fall 2009 semester, the Spring 2010 semester, or both,



Q. Select only those course_id values for courses that are offered in both the Fall 2009 and Spring 2010 semesters.



Q. Find all the courses taught in the Fall 2009 semester but not in Spring 2010 semester.



Q. “Find all students who have taken all courses offered in the Biology department" [ Hint : course ( course_id, title, dept_name, credits ) , student ( ID, name, dept_name, tot_cred ) and takes ( ID, course_id, sec_id, semester, year, grade ) ]


Previous Next