Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 ??? enter image description here
share|improve this question
    
This is a flat out answer my homework question. I don't mind helping but at least put some thought in before asking. –  Zane Nov 8 '12 at 16:38
add comment

2 Answers

up vote 2 down vote accepted

I would say, example-B

If you are using example A, then it is meaningless to save raw data in database; you can use plain text!

Example B supports searching for Doses, items related to Fever etc. (In example A you need to parse data).

Reducing the number of tables in a database is not an optimal solution. You have to normalize your data in order to select records based on a heavily conditioned search query (like, get all drugs for adults etc.)

share|improve this answer
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.