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 ???