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


+ Link For Assignments, GDBs & Online Quizzes Solution


+ 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.

(CS403)   DBMS

Assignment # 03

Total marks = 20

                                                                                       Due Date =


Lectures Covered =

lectures 1-36  


Assignment Guidelines:

Instructions for the assignment preparation:

  • You are required to make a presentation file (.ppt or .pptx) for your assignment solution
  • Presentation will consist of maximum of 4 – 5 slides
  • First slide will contain student name and ID
  • Remaining slides will contain the solution of the assignment
  • You have to formally present your assignment with proper dress code and have to record the video of your presentation
  • You can use any video recording facility such as web cam, camera, mobile phone etc. for recording of your presentation (See the tutorial “Tips for Recording Videos.mp4” available at download section of VULMS). Click here to download video file.
  • In first slide, you will mention your name and ID, and in remaining slides, you will be required to explain your solution given in your presentation file.
  • Your introduction and solution explanation should not take more than 4 to 5 minutes
  • After recording of your presentation, you have to convert your video in “.3gp” format using any video conversion tool to reduce the size of the video file. (See the tutorial “Video Compression.mp4” available at download section of VULMS). Click here to download video file.
  • After converting the video in .3gp format, review your file to verify that audio and video are properly playing. 
  • Install VLC media player to view your compressed video before uploading on VU-LMS. You can download VLC from http://www.videolan.org/vlc/download-windows.html.
  • It is preferable to use English in your presentation in case of reluctance you can also use Urdu language.
  • Note that you will record your presentation standing in front of camera.

Weightage of Assignment:

  • This assignment has 5% weightage of your overall marks of this course.

Instructions for the assignment submission:

  • Save your assignment with your ID (e.g. bc020200786.rar)
  • Make sure that size of assignment file should not exceed 30 MB

For any query please contact: CS403@vu.edu.pk

Assignment Task

Note: You are given one topic for your presentation. Instructions for solving the assignment are given at the top.


You are required to explain Inner Join and Outer Join. You need to explain this topic with the help of SQL example

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


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


Replies to This Discussion

let sstaarrt here??

This 45 minutes practical Lectures will cover your full assignment with 100% gurantee. 

it include an online practical environment where you can test your queries along with Data. for any query you can reach me. and online query environment is as below


user    cs403

pwd   cs403

Best of luck

Critics on video duration please keep your comment with you it will be needed for somewhere else. Joins topic if you cover in 45 min it means u are the CHAMPS

 Wahh sir g aap to advanc m hi sb assig solve krty ja rhy hain 

ya vu aap se puch k assig deny lg pri hai


Its True sir, these few videos put me back to studies, so simple and friendly explanations gave me cumbersome experience and provoked my thinking.

after watching them i consulted my handouts and everything went into my mind like i have already studied DBMS in my previous semester. 

I as a student would like to suggest to watch to those who really want to learn, and don't want to bow to others for help in assignments.

But no comment for those who just want beg and get the degree, its their own will. And its always true that one can make his fate according to his own will.

Very helpful lecture regarding this assignment. it is complete explanation of handouts lecture 31. Just concentrate on this lecture and read lecture 31 then u can prepare solution easily 

very easy assignment, soon i will upload some useful stuff or complete solution of this assignment, that will contain Screen shot of joins ...........u can't copy that 

Inner Join

Only those rows from two tables are joined that have same value in the common attribute. For example, if we have two tables R and S with schemes R (a, b, c, d) and S (f, r, h, a), then we have ‘a’ as common attribute between these twit tables. The inner join between these two tables can be performed on the basis of ‘a’ which is the common attribute between the two. The common attributes are not required to have the same name in both tables, however, they must have the same domain in both tables. The attributes in both tables are generally tied in a primary foreign key relationship but that also is not required.

excellent alvina, keep it up and also solve the assignment i provided. i am attaching here as well.


To understand join and practice at your own system u need to intall SQL Server and one sample db which i used in case study follow the video after downloading setups


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

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