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.
7 replies on “DPS VK SQL Assignment Solutions”
LOL , this is funny, but aint right.
Assignments should not be copied until you are in college.
Ah, so a step ahead of others, are we… 😉
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.
@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.
Referring to Google Docs eh? Caught you there Yahoo Scum!
Proud of you mate for promoting OSS Standards!
Expected me to comment, so I did!
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.