We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & 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 

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 206

.

+ 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)

Attachments:

Replies to This Discussion

PLEASE SHARE THE SOLUTION OF THE ASSIGNMENT 4

Assalamo alekum

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.

Rabia g agr ap nay asingment ker li ha tu kindly share ker dain thanks in advance
Rabia plz agar ap assignment bana chkee hai to usay shere karain humai bilkul bhi samaj nahi aa rahai plz upload it
Solution of CS 403 by adeel watto
  1. Show all the Instructor names with their taught Course IDs, Course Names and their concerned departments.

            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;

 

  1. Show all the instructor names and their concerned student names.

     SELECT instructor.insName, student.name FROM student INNER JOIN(instructor INNER    

             JOINcourse ON instructor.insId = course.insId) ON student.stuId = course.stuid;

 

  1. Show all those Student names who are not studying any course from Management department.

            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"));

 

  1. Show all those student ids, student names and their concerned instructor names that are studying CS001 or CS101 but not studying CS402.

            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

           "cs402"));

 

  1. Show all those course ids and course names taught by Dr Altaf or Dr N A Malik. 

     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"));

Dear fellows

u can change these sql quries by using different other operators.think about it.it'll help u in exam.thanx

Ap share kardu na solutions
Download Attachment..!!
Attachments:
Thank Yu MaaNi ...........

RSS

Latest Activity

+"Certified Gangster"++ replied to +"Certified Gangster"++'s discussion For all female friends
30 seconds ago
+"Certified Gangster"++ replied to +"Certified Gangster"++'s discussion For all female friends
1 minute ago
ASIM MAQSOOD posted a discussion
18 minutes ago
♦_"Tooba"_♦ replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion 2019 Noble Prize Winners
38 minutes ago
+ ! ! RebeL updated their profile
39 minutes ago
♦_"Tooba"_♦ liked + "αяsαℓ " Ќąƶµяɨ •"'s discussion 2019 Noble Prize Winners
40 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Muhabato me li gaye kasmain
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Muhabato me li gaye kasmain
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + ! ! ! AA g❤️ ! ! ! +'s discussion ++!!!!!!!EARTH QUACKS!!!!!!!!!!++
1 hour ago
彡JK彡 ❤️ replied to 彡JK彡 ❤️'s discussion Dedicated To All Fake IDs............ :p:p
1 hour ago
♦_"Tooba"_♦ commented on ♦_"Tooba"_♦'s status
1 hour ago
+ ! ❤INNOCENT❤ replied to + ! ❤INNOCENT❤'s discussion Akhri Salam Smjh kr
1 hour ago
+ ! ❤INNOCENT❤ replied to + ! ❤INNOCENT❤'s discussion Akhri Salam Smjh kr
1 hour ago
ϝ ι ყ α replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Muhabato me li gaye kasmain
1 hour ago
Nouman Butt replied to ♦_"Tooba"_♦'s discussion Guzri Howi Zindagi Ko Kabhi Yaad Na Kr
1 hour ago
+ ! ! RebeL replied to + ! ! ! AA g❤️ ! ! ! +'s discussion ++!!!!!!!EARTH QUACKS!!!!!!!!!!++
1 hour ago
Nouman Butt liked ♦_"Tooba"_♦'s discussion Guzri Howi Zindagi Ko Kabhi Yaad Na Kr
1 hour ago
♦_"Tooba"_♦ updated their profile
1 hour ago
+ ! ! ! AA g❤️ ! ! ! + replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Muhabato me li gaye kasmain
1 hour ago
Nouman Butt liked +¢αяєℓєѕѕ gιяℓ's discussion ❤️ وہ رو دیا تھا مجھ کو پریشان دیکھ کر
1 hour ago

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service