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


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

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: 238

.

+ 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

Binte Ahmed replied to Mani Siddiqui BS VIII's discussion Heavy Raining in Karachi
25 minutes ago
Rosetta added a discussion to the group ENG201 Business and Technical English Writing
26 minutes ago
Binte Ahmed liked Mani Siddiqui BS VIII's discussion Heavy Raining in Karachi
27 minutes ago
Shanzay liked +!!! Alan Walker !!!'s discussion kya mai writer ban sakti hon
2 hours ago
Rabia Imran posted a status
"cs301 assingment no3 send me solution"
3 hours ago
Muhammad Bilal liked + ! ! ! ! ! ! CS619's discussion CS619 Project
3 hours ago
Munna Bhai MBBS and Rabia Imran are now friends
3 hours ago
Bilal.Khan posted a status
"CS302 Assignment #1 required..."
3 hours ago
+ عاتکہ replied to + Ḱẚảḿḯ's discussion Mohabbat
3 hours ago
+ عاتکہ liked + Ḱẚảḿḯ's discussion Mohabbat
3 hours ago
+ عاتکہ replied to Mani Siddiqui BS VIII's discussion Heavy Raining in Karachi
3 hours ago
+ عاتکہ liked Mani Siddiqui BS VIII's discussion Heavy Raining in Karachi
3 hours ago

Today Top Members 

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

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

.