We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
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.
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.
For complete assignment see attached file plz
.+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)
+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)+ Click Here to Search (Looking For something at vustudents.ning.com?) + Click Here To Join (Our facebook study Group)
use join in all queries.
use like or not like operator in last 3 queries according 2the reqrmnt.
before uploading the asgmnt plz test ur queries e.g in ms-access or in oracle.
SELECTinstructor.insName, course.couId, course.couName, department.depName
FROM department INNER JOIN (instructorINNER JOIN course ON instructor.insId =
course.insId) ON department.depId = instructor.depId;
SELECT instructor.insName, student.name FROM student INNER JOIN(instructor INNER
JOINcourse ON instructor.insId = course.insId) ON student.stuId = course.stuid;
SELECTstudent.name FROM student INNER JOIN ((department INNER JOIN instructor ON
department.depId = instructor.depId) INNER JOIN course ONinstructor.insId = course.insId)
ONstudent.stuId = course.stuid WHERE (((department.depName) Not Like"Management"));
SELECTstudent.stuId, student.name, instructor.insName, course.couId FROM studentINNER
JOIN((department INNER JOIN instructor ON department.depId = instructor.depId)INNER
JOINcourse ON instructor.insId = course.insId) ON student.stuId = course.stuidWHERE
(((course.couId) Like "cs001" Or(course.couId)="cs101" And (course.couId) Not Like
SELECT course.couId, course.couName, instructor.insName FROM instructor
INNER JOIN course ON instructor.insId = course.insId WHERE
(((instructor.insName) Like "Dr N a naik" Or (instructor.insName)="Dr Altaf"));
u can change these sql quries by using different other operators.think about it.it'll help u in exam.thanx