Database Design Best Practices [closed]

Solution 1:

A few points:

• Learn as much as you can about problem domain. You can't create good data model without knowing what you're designing for
• Have good knowledge about data types provided by your database provider
• How to properly use normalisation and design tables
• Performance: when and how to apply indexes, how to write efficient queries etc.
• When and how to use different DB objects like views, procedures, functions, triggers

Solution 2:

There are numerous database design patterns. They aren't often nicely formalized, so you may have to simply look at lots of database design.

See, for example, Fowler's books on design patterns. Also Nock's Book.

There are blogs, like database programmer.

There's an IEEE book, On Pattern-Based Database Design and Implementation.

The Google Search (link) turned up 24M hits.