Categories
Uncategorised

Blogging Opportunities from Smorty

Bloggers are always looking for avenues to generate revenue from their blog – for recovering expenses incurred in technical requirements of their blog, like renewing domain names, getting storage, et al. The point is, bloggers put in a lot of time doing this stuff, and getting paid for it only makes them feel better about it that they aren’t exactly whiling away their time. Here’s blog advertising marketplaces like Smorty come in – in helping advertisers and bloggers find each other.

Smorty is a really nice looking site (and loads faster too than its competitors). I liked Smorty, for ahem, it’s good color scheme, and the fact that it is far less restrictive in its guidelines than its competitors. Freedom in expressing is exactly what I want. Setup is a breeze – no codes to install, and blogs are approved pretty quick. And unlike other sites of a similar kind which NEED posts to be approved, posts on Smorty are auto-approved unless objections are raised within five days. Good for bloggers, innit?

Categories
Uncategorised

DPS VK SQL Assignment Solutions

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.