Following is a TechRwpublic article which highlight five common mistakes that we tend to do in some situations.
Five common mistakes in database design
I have seen in many cases that the teams unintentionally doing these mistakes, but the catch is here that we can’t always go by the rules. We have to consider the other factors such as time lines, business value, end user expectations, performance, cost, quality etc. What I believe is that we as part of the development team needs to have a balance in all aspects related to software development. That is if we would try to implement rules to avoid mistakes mentioned in the above article we may well have to sacrifice many other things. So the knowledge of the business domain, the technology used and the capability of the team will determine the successful end product.
But as a convention we must always take all the necessary measures to make no mistakes at design level so take as much time as possible to do it right at the first place.
TechJukeBox 