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

Object Oriented Programming (CS403)

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.

+ Click Here To Join also Our facebook study Group.

..How to Join Subject Study Groups & Get Helping Material?..


See Your Saved Posts Timeline

Views: 908

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

Replies to This Discussion

An inner join is a join where the only results displayed are results where the keys are in both tables. An outer join will display the results for all keys in one tables, a left join from the first and a right join from the second. For example:

Let's say table1 has the following primary key and data pairs: (1, a), (2, b), (3, c)

Let's also say that table2 has the following primary key and data pairs: (1, fun), (3, can), (4, happen)

So an inner join of table1 to table2 on the primary keys would yield the following resulting triplets (with the common primary key first, the first table's second item second and the second table's second item third): (1, a, fun), (3, c, can)

A left outer join of table1 to table2 on the primary keys would yield the following resulting triplets (same format as above): (1, a, fun), (2, b, NULL), (3, c, can)

A right outer join of table1 to table2 on the primary keys would yield the following resulting triplets (same format as above): (1, a, fun), (3, c, can), (4, NULL, happen)

some body please explain the inner and outer joins with SQL examples...

Follow my videos you will get 100% understanding and will be in condition to explain the topic to other inshallah.

First of all make correction this is not Object Oriented Programming CS403, this is DBMS.

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

http://vuacademy.com/mysql

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

Slides for Join is attached here which u need to  understand the concept

Attachments:

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

Choose the database "db4join" once you login for the practice

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

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

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