The following is the database schema used to track blood donations. The database has been in use for several years and contains thousands of entries. Primary keys are RID in Receptionist, DID in the donor, BID in Blood, NID in Nurses, PatientID in Transfusions and foreign keys carry the same names as the primary keys they reference.
Receptionist (RID, Name, Address, Phone#)
Donor (DID, Name, Address, Phone#, SSN, gender, DOB)
Blood(BID, Blood_type, Cost, DID, NID)