Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
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.