TRNC government wants to create blood donation system in order to apply it in mobile clinics

and hospitals. They want to have information's about donor names and assign them unique IDs

in order to track the availability of those donors. If an emergency alarm is triggered the

government want to have address information and contacts about those donors. Donor's details

should have critical information such as blood type, last donation date about donors, medical

report, and contact number.

Similarly, add patient names with unique IDs, details on their

medical conditions, and blood types. After you've created a database of patients and donors, you

can work on a database for the blood bank. There, you'll have to add the name of the blood bank,

its staff details, operating hours, and address.

You must apply this project using the database concepts we learn in the course, meanwhile, you

should apply ER-diagram EER-diagram and normalization to your project. This project could be

applied in any DMBS. The SQL queries must be stored in .sql file extension where it should be

applicable to be imported, the tables and contents of all records must exists after importing on

another DBMS server. You must show examples about all entity integrity concepts.

use postgresql server

and please i want someone to answer it by drawing the diagrams and writing the code

there is alot of answers in chegg but they are wrong

Functional documentation TRNC government wants to create blood donation system in order to apply it in mobile clinics and hospitals. They want to have information's about donor names and assign them unique IDs in order to track the availability of those donors. If an emergency alarm is triggered the government want to have address information and contacts about those donors. Donor's details should have critical information such as blood type, last donation date about donors, medical report, and contact number. Similarly, add patient names with unique IDs, details on their medical conditions, and blood types. After you've created a database of patients and donors, you can work on a database for the blood bank. There, you'll have to add the name of the blood bank, its staff details, operating hours, and address. You must apply this project using the database concepts we learn in the course, meanwhile, you should apply ER-diagram EER-diagram and normalization to your project. This project could be applied in any DMBS. The SQL queries must be stored in .sql file extension where it should be applicable to be imported, the tables and contents of all records must exists after importing on another DBMS server. You must show examples about all entity integrity concepts. Recommendation: use postgresql server for implementation