How can I store blood details so that I can keep track of them in database?

Question

1.00/5 (1 vote)

See more:

Can someone tell me which way is better to store blood details like A+,O+,etc..

Bloodgroup is A,B,AB,O...
Bloodtype is positive, negative..

I need to keep track of the blood details like O+ in my blood inventory.

What I have tried:

Instead of placing bloodgroup and bloodtype in donors table, can i just do it as shown below?

C#

Donors : donorID, bloodGroupID, bloodTypeID, ..etc
BloodGroups : bloodGroupID, remarks..etc
BloodTypes : bloodTypeID, remarks..etc

or

C#

Donors : donorID, bloodID, ..etc
Bloods : bloodID, bloodGorup, bloodTypeID, remarks..etc
BloodTypes : bloodTypeID, remarks..etc

Posted 8-Dec-16 6:18am

心心傷心

Updated 8-Dec-16 7:56am

CHill60

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2016-12-08T07:56:00

As there are only 8 blood types

O+
O-
A+
A-
B+
B-
AB+
AB-

I think it could be overkill to normalize the database to the extent you have suggested, and could just store the Blood Type as a VarChar. But you imply that you may want to store remarks against each one (e.g. the estimated percentage of population with each type, or a "ranking" on rarity) and of course you may want to populate a dropdown with the valid entries. So...

Personally I would have a BloodTypes table with the 8 rows listed above, and store the BloodTypeID against a person (donor).

I (personally) wouldn't bother to take it to the extra level of separating out the blood groups as I don't think it's necessary, efficient or conducive to ease of use and understanding. Purists may think differently.