Discussion on:

Message 33 of 97
0 Votes
+ -
The point I was making was
Access is horrible tool to teach relational database theory with.

It's also an awful tool to teach SQL with.

The 'reverse' would be command line Osql would be a horrible power user tool for an MBA....

And of course, completely and totally irrelevant.

Unfortunately, or fortunately depending on how you look at it, there are a lot of devs doing database design and sql (well sort of). A horrifying percentage of them quite obviously don't get either, I should know I get paid to tidy up after them.

I don't expect a dev to know 6NF (I don't), I don't expect them to be able to tune a partitioned databasde over a raid (I can't), or set up a cluster (woudln't no where to start)

I do expect them to know up to 3NF, and that you don't do select * from Table, suck everything on to a clients and then iterate through with next to find the one called Bill and set his surname to Gates.

I suppose I might be expecting too much, I mean a lot of them can't program either....
Posted by Tony Hopkinson
12th Oct 2010