CS403 Assignment No. 4 Announced
Thursday, January 06, 2011 Posted In CS and IT Edit ThisAssignment No. 04
Semester Fall2010
Database Management Systems-CS403
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)
Show all the Instructor names with their taught Course IDs, Course Names and their concerned departments.
Show all the instructor names and their concerned student names.
Show all those Student names who are not studying any course from Management department.
Show all those student ids, student names and their concerned instructor names that are studying CS001 or CS101 but not studying CS402.
Show all those course ids and course names taught by Dr Altaf or Dr N A Malik.
| Student ID | Name |
| Vu001 | Salman |
| Vu002 | Ramzan |
| Vu003 | Faizan |
| Vu004 | Usman |
| Vu005 | Zeshan |
Student
Instructor
| Instructor ID | Instructor Name | Department ID |
| I-001 | Dr Altaf | 1 |
| I-002 | Dr N A Malik | 1 |
| I-003 | Dr Mukhtar | 2 |
Course
| Course ID | Course Name | Student ID | Instructor ID |
| CS001 | CPL | Vu001 | I-002 |
| CS101 | Intro to computing | Vu002 | I-002 |
| CS201 | Intro to Programming | Vu004 | I-001 |
| CS301 | Data Structures | Vu002 | I-001 |
| CS302 | DLD | Vu003 | I-002 |
| CS304 | OOP | Vu001 | I-001 |
| CS402 | Theory of Automata | Vu004 | I-002 |
| CS403 | DBMS | Vu003 | I-001 |
| CS408 | HCI | Vu005 | I-002 |
| MGT501 | HRM | VU001 | I-003 |
| MGT502 | | VU002 | I-003 |
| Department ID | Department Name |
| 1 | Computer Science |
| 2 | Management |
Department
| |
Guidelines / Instructions
- Understand the scenario on the basis of given data only.
- Write only SQL statements, don’t show any data.
“Try to upload the assignment before BONUS day”
