Latest Activity In Study Groups

Join Your Study Groups

VU Past Papers, MCQs and More

We non-commercial site working hard since 2009 to facilitate learning Read More. We can't keep up without your support. Donate.

(CS403)   DBMS

Assignment # 03

Total marks = 20

                                                                                       Due Date =

07/08/2016

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.

Topic:

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

Views: 3171

Attachments:

Replies to This Discussion

let sstaarrt here??

 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.

https://www.youtube.com/watch?v=ens3WN3qY58&index=10&list=P...

watch this video and i hope you will be able to solve your assignment yourself.

good luck

very nish sk sir Great work

Please Discuss here about this assignment.Thanks

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions.

 

RSS

Looking For Something? Search Below

Latest Activity

VIP Member Badge & Others

How to Get This Badge at Your Profile DP

------------------------------------

Management: Admins ::: Moderators

Other Awards Badges List Moderators Group

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

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