01-10-2011, 06:03 PM
Q 1: Write SQL statements/queries to show the data for each of individual scenario given below from the given tables on the next page. 15 marks (3+3+3+3+3)
1. Show all the Instructor names with their taught Course IDs, Course Names and their concerned departments.
2. Show all the instructor names and their concerned student names.
3. Show all those Student names who are not studying any course from Management department.
4. Show all those student ids, student names and their concerned instructor names that are studying CS001 or CS101 but not studying CS402.
5. Show all those course ids and course names taught by Dr Altaf or Dr N A Malik.