Recent content by iancg1

Wow! So many ideas rushing in! :) I have more questions, but before that I'll give a little more background on the project. The database is primarily for keeping records of the members in the Pledge 25 program. These members are the youth, aged 18 to 25, who pledge to be regular blood donors...

Hi there, I attached the database as a zip file. I appreciate the feedback.

How do I know if I should use a one-to-one, one-to-many, or many-to-many relationship?

Can someone check if I have the relationships correct? Thanks!

By the way, what does "reinforce referential integrity" mean when creating relationships?

Thanks. At this point are the tables good to go? :)

Thanks. So now the synthetic DonorID (autonumbered) will be the one related with the other tables and not the ID number issued by our office?

This might be a problem, donors become full-fledged members when they make their first donation, which must be recorded. However, their ID card (with their ID number) will be given to them around a week later. Can their donation be recorded even if they don't have an ID number yet?

Thanks, I'm sorry that includes AB+ and AB- so that makes 8 :)

How do I assign a foreign key?

Thanks. For the Blood Type table, there are only three basic types, A, B, and 0, and each can either be Rh (+) or (-). Which will be BloodTypeID and BloodTypeName?

Thanks for replying. PK is Primary Key right? What is FK? Sorry, I'm very new to this. :o

Good day all! I'm Ian, a youth volunteer from the Philippine Red Cross. We have this program called Pledge 25 where we recruit young people (between 18 to 25 years of age) to be regular blood donors and pledge to donate blood at least 3 to 4 times a year. Despite the intensive blood drives, our...