Database design – Back to basics

Over my 15 years of developing with Microsoft Access, I have found myself adding functionality onto existing databases that I have inherited so to speak and sooner or later found that my clients database was not grounded from sensible database design and so the scalability is severely stunted and has little room for expansion and being useful to the users. I always find myself going back to basics and mentally sitting those first classes at college to mull over the relational database and normalisation of the data you want to store and ultimately the information you wish to extract from it.

This shows that it is vital to spend time with the client, understand their needs implicitly in order to root in a solid database design allowing scalability as one day they may well expand , require an upscale to SQL server, where this will pay dividends.

16 thoughts on “Database design – Back to basics

  1. Its like you read my mind! You appear to know a lot about this, like you wrote the book in it or something. I think that you could do with some pics to drive the message home a little bit, but other than that, this is wonderful blog. A fantastic read. I will definitely be back.

  2. It¡¦s actually a nice and helpful piece of info. I am satisfied that you simply shared this useful information with us. Please keep us up to date like this. Thank you for sharing.

  3. Pretty nice post. I just stumbled upon your weblog and wanted to say that I have truly enjoyed surfing around your blog posts. In any case I’ll be subscribing to your feed and I hope you write again soon!

  4. what’s up http://www.linearsolutions.co.uk admin discovered your website via yahoo but it was hard to find and I see you could have more visitors because there are not so many comments yet. I have found site which offer to dramatically increase traffic to your site http://xrumerservice.org they claim they managed to get close to 1000 visitors/day using their services you could also get lot more targeted traffic from search engines as you have now. I used their services and got significantly more visitors to my site. Hope this helps :) They offer most cost effective backlinks service Take care. Jason

  5. Great web site. Plenty of helpful info here. I¡¦m sending it to several friends ans also sharing in delicious. And obviously, thank you in your sweat!

  6. Howdy very cool site!! Guy .. Beautiful .. Amazing .. I’ll bookmark your site and take the feeds also¡KI am happy to search out so many helpful info here within the submit, we need work out extra strategies in this regard, thanks for sharing. . . . . .

  7. I like what you guys are up too. Such smart work and reporting! Keep up the excellent works guys I¡¦ve incorporated you guys to my blogroll. I think it’ll improve the value of my site :)

  8. I have been surfing online greater than 3 hours lately, yet I by no means discovered any attention-grabbing article like yours. It¡¦s pretty value sufficient for me. In my view, if all webmasters and bloggers made excellent content as you did, the internet shall be much more helpful than ever before.

Leave a Reply