What is the best mechanism for database designing ?

The best way to design a database is first to find out all entities and All attributes of a entity and  relationship between them.Then make table according to your entity and columns according to its attributes and maintain relationship using foreign keys.

I think the brain of the database expert :-)

Its purely based on the systems requirements and business analysis.