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

.

+ 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

thnx bhai :)..men kar rahi ,Allah karay ab hojae :)

actually mostly every student is selecting wrong data type

Hint:  hire_date datetime will not because data is in  charaters and number  '15-JAN-2011'  11 character required so use your brain

best regards

can anyone tell me the link for downloading the sql software for win7 64bit window...

brother if you are using 64 bit OS then you need to first install dotnet framework 4.0 and  after rebooting your pc install sql server express

Dot net framework download link : http://www.microsoft.com/download/en/details.aspx?id=17718


Microsoft SQL server 2005 download torrent link : http://www.mediafire.com/?40r127pazr9agvp (its a torrent link so you need torrent client and good net speed)

RSS

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

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