Google PlusFacebookTwitter

DPS VK SQL Assignment Solutions

By on Jun 10, 2007 in On A Whim | 7 comments

Share On GoogleShare On FacebookShare On Twitter

I’ll make this quick, because I’ve some work to do right now. These are the solutions to the SQL assignment given for class 12 at DPS VK, along with the questions. You can download the SQL assignment archive by clicking here. You’ll find the PDFs which have the info, and just in case you want to format something, I’ve included the master document too, in OpenDocument Text format; which you can open by using OpenOffice 2.2 (it’s a free download) or by uploading it to an online service like Google Docs.

Note that I haven’t tested the thing on a database to ensure these are correct, but I think they are. In case you detect any error, please do notify me (the email address is at the bottom of this page). Do note that in questions related to date related queries, the way the date is entered will depend upon your software’s implementation of SQL. Also, in one assignment the question requires the use of ALTER TABLE command – it’s not supported in ANSI, so if your software strictly follows that it might not work.


  1. Ankit

    June 10, 2007

    Post a Reply

    LOL , this is funny, but aint right.

    Assignments should not be copied until you are in college.

  2. Vivek Nair

    June 12, 2007

    Post a Reply

    I know (as much as the rest of the universe) that you are an ardent supporter of open source standards. But giving out your files (DPS VK SQL Assignments) in Open Office Document is a bit too much. 99% people don’t have OpenOffice, and they don’t have the time to download 100+ MB just to view your document. And most people are not comfy with Google Docs.

  3. GQ

    June 12, 2007

    Post a Reply

    @Vivek: As for the docs, most of my users would be interested in tepna and chapna. For them, the PDF files are ready for printing. And OpenDocument makes the whole thing so much smaller – a Microsoft Doc file which has a say 100 KB size is only 14 KB in ODT. Advantage, innit? I know must of them won’t need to edit the file, and I only included it to induce a curiosity factor which might prompt them to download OpenOffice.

  4. Prashanth

    June 12, 2007

    Post a Reply

    Referring to Google Docs eh? Caught you there Yahoo Scum!
    Proud of you mate for promoting OSS Standards!

  5. GQ

    August 8, 2007

    Post a Reply

    Although not related, I also added the ‘C++ Code Archive’ tag to this post to make it easier for our school students to find it.

Submit a Comment

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.