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

 

INSTRUCTOR_ID

FIRST_NAME

LAST_NAME

LAST_ DEGREE

SALARY

CITY

HIRE_DATE

50

AHMAD

ALEEM

MS

40000

ISLD

15-JAN-2011

55

MUHAMMAD

HASAN

MS

42000

ISLD

16-FEB-2010

60

TALHA

ALI

Phd

80000

LHR

18-JUN-2008

70

HANNAN

NAWAZ

Phd

76000

LHR

20-DEC-2008

80

WAJID

ALI

MS

45000

LHR

09-AUG-2008

85

ASIF

AHMAD

MIT

50000

MUL

19-MAY-2010

90

TAHIR

MOHSIN

MCS

38000

MUL

27-FEB-2009

95

BAKIR

NAWAZ

MS

40000

ISLD

12-AUG-2011

100

SUMAIR

AHMAD

Phd

90000

ISLD

07-APR-2008

 

Use the following tables to solve this assignment.

                  

       

                    Table 1: INSTRUCTOR TABLE

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

        

                 

                  Table 2: STUDENT TABLE

STUDENT_ID

STU_NAME

SEMESTER

SPECIALIZATION

INSTRUCTOR_ID

1

AHMAD

2

NETWORKS

50

2

ASIM

2

NETWORKS

55

3

SAJID

3

DATABASES

60

4

SHUJA

4

AI

70

5

ZEESHAN

1

DATABASES

80

6

HASEEB

2

SOFTWARE ENGINEERING

85

7

MUDASSAR

3

SOFTWARE ENGINEERING

90

8

QASIM

3

DATABASES

95

9

WAHEED

4

NETWORKS

100

 

 

                You are required to write a SQL query to display the following output table:

 

STUDENT_ID

LAST_NAME

LAST DEGREE

HIRE_DATE

INSTRUCTOR_ID

INSTRUCTOR_ID

STU_NAME

1

ALEEM

MS

15-JAN-2011

50

50

AHMAD

2

HASAN

MS

16-FEB-2010

55

55

ASIM

3

ALI

Phd

18-JUN-2008

60

60

SAJID

4

NAWAZ

Phd

20-DEC-2008

70

70

SHUJA

5

ALI

MS

09-AUG-2008

80

80

ZEESHAN

6

AHMAD

MIT

19-MAY-2010

85

85

HASEEB

7

MOHSIN

MCS

27-FEB-2009

90

90

MUDASSAR

8

NAWAZ

MS

12-AUG-2011

95

95

QASIM

9

AHMAD

Phd

07-APR-2008

100

100

WAHEED

 

 

 

      Our Expectations: Hopefully, you all would be fine. Here in this practice assignment. You all are required to create two tables (Instructor, Student) using SQL CREATE TABLE statement in SQL Server. Example CREATE TABLE practice queries have also been uploaded in “Downloads” section under VULMS.

 

           We need screenshots of all your work, which will be pasted in your solution file (DOC File).

 

Marks Distribution will be as under:

 CREATE TABLE Commands          =   5 (2.5 for each table) marks

 INSERT INTO Table Commands    =   5 (2.5 for each table)  marks    // For time saving you can only insert three records in each table.

 SELECT Query                                  =  10 marks

 

+ Click Here To Join also Our facebook study Group.

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


See Your Saved Posts Timeline

Views: 8347

.

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

Attachments:

Replies to This Discussion

Please Discuss here about this assignment.Thanks

You don’t need to go any other site for this assignment/GDB/Online Quiz solution, Because All discussed data of our members in this discussion are going from here to other sites. You can judge this at other sites yourself. So don’t waste your precious time with different links.

 

sir i want to say that there is only unsolved assignment no 4 .we need some solution

please upload that.............regards

sir i never do studies like this ...copy and paste. i just want some discussion about this assignment.
Right now im doing this assignment by meyself. .. but thanks for ur advice

ya sara khan ma tu khud kihata huta hun k main purpose hamara discussion hai na k solution..

or ma mostly discussions ma ya comment add karta huta hun islihay.

Dear Fellows,

All of you are requested, Please post Only One Discussion For Current Assignment/GDB/Online Quiz and everyone reply/share/discussed his/her data on that same discussion, so that all members get solution & discuss easily on Current Assignment/GDB/Online Quiz.

So please don’t post two or more discussions for one Current Assignment/GDB/Online Quiz, hope you’ll understand and cooperate with us.

Our main purpose here discussion not just Solution.

CS403 100% solution 4th assignmnt spring 2012 

enjoy it remember me in ur prayers.........

Tariq bhai ap ki file e open ni ho rahi

kesy ho gi ye open?

+ Zara kon si file ki bat kar rahi hu ap ?

ya ju above Hinna wali hai ??

is pa right click karo or save as image kar lu bas simple

tariq bhai ap ye solution file sahi taran upload karain ye download nai ho rha

file not download.

please again share solution file

ye solution last assignment ka ha...plzzz is wali ka kr de upload

sir g .... kereee file enjoy krie

xplain

Ok,thanks a lot Tariq Bhai,

RSS

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

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