أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
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.