what is the best choice from those two tables? what is the best choice from those tables??


table A : keep DB simple with lower number of tables ... but i will find difficulties if i wanted to extract certain data from column of doses coz it's crowded with age ranges and doses and many routes of admin ... so if i wanted to make analysis for example: all doses given i.v. through all my DB.. i will face difficulties
table B : it make things arranges in separated tables, so it will be easier to retrive data easily..but for one point i had many tables and i have to link them to each others
now i ask: what is the best way to manage my DB and for querying data from it effectively and easily .. following example A or example B ???
Option B is correct.

Quite simply: each row/column stores one and only one item of information

A multiple table design is quite normal: it comes out of the normalisation process which starts with option A as your business data model.