Hey there, sarcasm lovers! This is Sars coming at you with a fantastically awesome and brilliant idea. This is for all you database developers out there who just love to mess with people's heads (ya, I'm talking about you).
Let's say you need to build a system for entering and tracking something like timesheets or invoices or purchase orders. Well, the first thing you want to do is ensure your system is really easy to enter information into — but virtually impossible to get anything out of. Because who doesn't love a good game of where-did-it-go?
Done? Brilliant. This is going to be frakkin' awesome.
Okay, now here's where it gets tricky. The next thing you want to do is toss a few surprises into the database. So, let's say your system requires dates to be entered in dd-mmm-yy format. For today's date, users would need to type the numbers 1 & 6, then the letters N, O, & V, then the numbers 0 & 9. Once they've got all the info entered on the screen, they would need to click a little button that says 'SUBMIT'.
But here's the kicker, instead of taking the info as read, sometimes you want to have your system play with it a bit. It's important that it only do this sometimes though. If it becomes too predictable, they might be able to figure a way of getting around it. So, let's say the user enters a timesheet dated 16-NOV-09, let that go through correctly. But if he enters one for 06-NOV-09, set your system to decide that he didn't really mean that. Have it throw 11-JUN-09 in to the system instead.
And because it's so difficult to get anything out and IMPOSSIBLE to change it, the user won't even know his date is wrong. He just won't get paid for the 6th of November, because of course he didn't work on that date.
Well, okay, if you do that, people might catch on too quickly. Instead, let the person change the timesheet manually (i.e. in pen) before submitting it as a hard copy to somebody in a different department (Duh! How else would you do it?). But keep collecting that worthless data in case somebody comes along one day and wants to use it for something.
And then a few years later you could pay somebody to come in and look at your system and pull out all this historical data and turn it into a bunch of sexy and glamorous reports. Let her try to figure out why the data's all screwy. Even if she happens to be a self-professed genius, it still might take her a few days to figure out what the hell you've done.
Awesome. Brilliant. Glorious. I love it.
If you can arrange to have this all done in an environment devoid of free coffee... Well, all the better.