CvLTAELG1AAv7GMjp8RSaPGsvS8 CS403 Assignments # 4 Solution Spring 2012 |
Friday , 14 December 2018
Virtual University New old assignments, papers, GDB, Quizzez
Newest Assignments
You are here: Home - CS403 - CS403 Assignments # 4 Solution Spring 2012

CS403 Assignments # 4 Solution Spring 2012



 

Use the following tables to solve CS403 assignment.

INSTRUCTOR TABLE


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

 

STUDENT TABLE

STUDENT_ID

STUDENT_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

STUTENT_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
Inser 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

Assignment No. 4 : Solution

You can also Download above solution from below button.

Download Spring 2012_CS403_4_SOL

Leave a Reply

Your email address will not be published. Required fields are marked *

*

*