10 Common Database Design Mistakes{4}

by Eric H
Its hard when design a database, but in the article it pointed how 10 of the common mistakes people make when design the database:
1. Poor design/planning
2. Ignoring normalization
3. Poor naming standards
4. Lack of documentation
5. One table to hold all domain values
6. Using identity/guid columns as your only key
7. Not using SQL facilities to protect data integrity
8. Not using stored procedures to access data
9. Trying to build generic objects
10.Lack of testing

When designing the database spending enough time and thinking it through it critical, and not to ignore proper planning phase just to get it done, It will waste more time to go back and fix a problem than just spend the time and plan it correctly in the first place. Secondly, do not ignore normalization. normalizing your data is essential to good performance and ease of development. Naming in database is always very important, keeping a consistent naming ruling when making a database can save a lot of headache down the road. Leaving definitions on its tables, columns, relationship, and even default and check constraints, making it clean to everyone how a function is tended to be used, it will be useful when going back to make changes or fix something (Davidson, 2007). Putting multiple tables into a single “catch-all” table simplify the design, it keeps a consistency in the whole design. The author pointed out another useful tips is each tables should have a natural key that means something o the users, and can uniquely identify each row in the table. All fundamental, non-changing business rules should be implemented by the relational engine. the base rules of nullability, string length, assignment of foreign keys, and so on, should all be defended in the database (Davidson, 2007). Another tips is stored procedures are your great, use them whenever possible as a method to insulate the database layer from the users of the data. Also we should avoid coding very generic objects, such as ones that take a table name and twenty column names and values pairs as a parameter and lets you update the values in the table(Davidson, 2007). A very important tips is to test your database, by testing it you will find out most of the problem and flaws in the database.

This relates to our class lectures because it points out the common mistakes people makes when designing and building a database. I learned now to rush the design phrase just to get things done fast, because i could be wasting more time by doing so. and being consistent in naming and defining the relations. And also to test the database when its done.

Davidson, L. (2007, February 26). Simple-talk. Retrieved from http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/