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.

 

Objective:

To learn and understand basic concepts of SQL.

Instructions:

Please read the following instructions carefully before solving & submitting assignment:

Assignment should be in your own wordings not copied from net, handouts or books.

It should be clear that your assignment will not get any credit (zero marks) if:

 

  • The assignment is submitted after due date.
  • The submitted assignment does not open or file corrupt.
  • The assignment is copied (from other student or copy from handouts or internet).
  • Student ID is not mentioned in the assignment File or name of file is other than student ID.
  • Assignment is not submitted in DOC file.

 

For any query about the assignment, contact at cs403@vu.edu.pk

 

GOOD LUCK

 

 

 

1(a). Consider the table below:                                          Marks: 5

 

                        Documentary Table

Doc_No

Title

Ranking

YearReleased

1

Hoop Dreams

A

1994

2

The Thin Blue Line

B

2000

3

Surprise Me

A

2004

4

Trouble the Water

C

2008

5

Dark Days

B

2000

6

Paris In Burning

B

1991

 

You are required to write an SQL statement using SELECT operator, which will give the following resultant table.

Title

YearReleased

The Thin Blue Line

2000

Dark Days

2000

Paris In Burning

1991

 

 

1(b). Consider the table below:                                     Marks: 5

                    

                      Documentary Table

Doc_No

Title

Ranking

YearReleased

1

Hoop Dreams

A

1994

2

The Thin Blue Line

B

2000

3

Surprise Me

A

2004

4

Trouble the Water

C

2008

5

Dark Days

B

2000

6

Paris of Burning

B

1991

7

Man on Wire

A

2008

    

You are required to show the resultant relation that will be produced by the following SQL SELECT statement.

SELECT Doc_No, Title, YearReleased     

FROM

Documentary

WHERE  YearReleased <>‘2000’;    

 

Upload Instructions:

Please view the document related to assignment submission process provided to you by the Virtual University to upload the assignment.

 

 

 

+ 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: 4889

.

+ 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

hmmm Adeel Aslam  

assignment in MSWord 2003

See the attached file please=

Attachments:

Rashid MEhmood u r nt correct abut qustn no 1 kyunke ranking ka table to hai nai select statement main is liye

There is nothing wrong with my solution.

i have checked it already. i have run SQL query the result was same as in the assignment file.

better for all if you run in SQL by yourself

SELECT Title,YearReleased
FROM Documentry
where ranking='B';



rashid bro u r also right....

Thanks dear

i check the solution file today. Alhamdoliilah i was right.

ANSWER 1

SELECT Title , YearReleased      from   Documentary     WHERE   YearReleased = 2000 or YearReleased =  1991 

CS403_Assignment#03_Solution

Attachments:
). Consider the table below: Marks: 5Documentary Table
Doc_No
Title
Ranking
YearReleased
1
Hoop Dreams
A
1994
2
The Thin Blue Line
B
2000
3
Surprise Me
A
2004
4
Trouble the Water
C
2008
5
Dark Days
B
2000
6
Paris In Burning
B
1991
You are required to write an SQL statement using SELECT operator, which will give the following resultant table.
Title
YearReleased
The Thin Blue Line
2000
Dark Days
2000
Paris In Burning
1991
Solution;
SELECT Title, yeaReleased
FROM Documentary
WHERE YearReleased <’2004’AND != ‘1994’;
1(b). Consider the table below: Marks: 5Documentary Table
Doc_No
Title
Ranking
YearReleased
1
Hoop Dreams
A
1994
2
The Thin Blue Line
B
2000
3
Surprise Me
A
2004
4
Trouble the Water
C
2008
5
Dark Days
B
2000
6
Paris of Burning
B
1991
7
Man on Wire
A
2008
You are required to show the resultant relation that will be produced by the following SQL
SELECT statement
.
SELECT Doc_No, Title,YearReleased
FROMDocumentary
WHERE YearReleased <>‘2000’
;
Solution;
Doc_No
Title
YearReleased
1
Hoop Dream
1994
3
Surprise Me
2004
4
Trouble the Water
2008
6
Pairs of Burning
1991
7
Man of Wire
2008

Anyone can tell how we can save sql file and which format file will be sent

main baat to ye hay k sent kis format main karni hay aur sql main file hard disk pe save kessy hoti hay

main nay try ke hay but jab save karin jo satatment open ho wo wordpad k format main save ho jati hay

bhai uc ka matlab hai k Assignment is not accepted if it is not submitted in DOC file.

SQL online download ho sakta hy kia 

LMS pe ja k cs403 ki course website pe para hua hai...app wahan se download kr lo...

RSS

Latest Activity

M_Asim left a comment for Aisha RD
4 minutes ago
Amjad Abbas posted a status
"thanks"
6 minutes ago
Profile IconAmjad Abbas, Nimra zahid, Aisha RD and 31 more joined Virtual University of Pakistan
8 minutes ago
+ Danial replied to +¢αяєℓєѕѕ gιяℓ's discussion Shadi Ho Rhi Hai Alhamdulillah.......... (^__^)!
10 minutes ago
+ Danial liked +¢αяєℓєѕѕ gιяℓ's discussion Shadi Ho Rhi Hai Alhamdulillah.......... (^__^)!
10 minutes ago
+ Iuuoɔǝut + posted videos
17 minutes ago
MUDASAR SHAKIL posted a status
"Mujhe Suspend kyon kar diya jata ha chat se yar"
20 minutes ago
ϝ ι ყ α replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Happy Marriage to "Zee" & " Nomi weds Noor"....!
41 minutes ago
Aiman posted a status
"Hello students I am new please tell me their is any student of Bs Psychology I have a problem to make Isl201 assignment please help me"
44 minutes ago
Scorpio liked +¢αяєℓєѕѕ gιяℓ's discussion Shadi Ho Rhi Hai Alhamdulillah.......... (^__^)!
47 minutes ago
Sidra Mustafa replied to + M.Tariq Malik's discussion MGT610 Business Ethics GDB Fall 2019 Solution & Discussion in the group MGT610 Business Ethics
1 hour ago
Sidra Mustafa joined + M.Tariq Malik's group
1 hour ago
Imran Khan replied to + M.Tariq Malik's discussion MTH601 Assignment No 01 Fall 2019 Solution & Discussion in the group MTH601 Operations Research
1 hour ago
Profile IconImran Khan, Hashim and Aakash Ahmed joined + M.Tariq Malik's group
1 hour ago
+ ! ! ! ! Mehαr Mαh꧂ replied to + M.Tariq Malik's discussion MGT201 Financial Management GDB Fall 2019 Solution & Discussion Last Date: 22-11-2019 in the group MGT201 Financial Management
1 hour ago
+ ! ! ! ! Mehαr Mαh꧂ liked + M.Tariq Malik's discussion MGT201 Financial Management GDB Fall 2019 Solution & Discussion Last Date: 22-11-2019
1 hour ago
+"Khwab Zaadi"+ liked + M.Tariq Malik's discussion MTH501 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 19-11-2019
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion MGT201 Financial Management GDB Fall 2019 Solution & Discussion Last Date: 22-11-2019 in the group MGT201 Financial Management
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion MGT201 Financial Management GDB Fall 2019 Solution & Discussion Last Date: 22-11-2019 in the group MGT201 Financial Management
1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + M.Tariq Malik's discussion MGT201 Financial Management GDB Fall 2019 Solution & Discussion Last Date: 22-11-2019 in the group MGT201 Financial Management
1 hour ago

Today Top Members 

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

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