A blood bank is a place where blood is collected and stored to be used by hospitals for those who need them either due to health emergencies or blood shortages. Blood banks are scattered all over places. So, it is important to have an organized database to help in allowing donors easily locate the nearest blood banks and donate blood, and also to make hospitals easily access blood when they need them within the shortest possible time.
Your task is to design and implement a centralized blood bank database that stores the following information:
• A Donor with the following attributes: Donor ID, Name, Date of birth, Gender, Address.
• A Blood unit donated by a donor. The blood unit attributes are blood code (unique), blood amount, donate date, blood type. Search Internet for blood types when populating the database.
• A Blood bank: blood bank ID, address.
• A blood bank manager is assigned to each blood bank. A manager can only be assigned to one blood bank. The blood bank manager attributes are manager ID, name, phone number.
• Hospitals can use blood from several blood banks, and a blood bank can provide blood to several hospitals. The hospital attributes are hospital ID, name, address, email.
• A donor always donates blood in the same blood bank.