create a full project with ERD by using these information.Do not forget to create all $7$ tables that i mention on picture.

Create a full project with ERD by using these information will be working on Oracle Database APEX

$12.$ Blood Donation System Database Project

A system in which data of patient, data of donor, data of blood bank would be saved and will be interrelation with each other.

Data of Patient $-$ Patient Name, Patient Id$,$ Patient Blood Group, Patent Disease.

Data of Donar $-$ Donar Name, Donar Id$,$ Donar Bood Group, Donar Medical report,

Donar Address, Donar Contact number.

Data of Blood Bank $-$ Blood Bank Name, Blood Bank Address, Blood bank Donor's name, Blood Bank Contact Number, Blood Bank Address.

Try to implement such scenario in a database, create a schema for it$,$ an ER diagram for it and try to normalize it$.$

must be these $7$ tables $,$ If you want you can add more tables and entities.

Tables: Patients, Donors, BloodBanks, Doctors, Bloodinventory, Blood test, Hospital.

Try to implement such a senerio in a database, create a schema for it$,$ an ER diagram for it and try to normalize it$.$ Dont forget to create all $7$ tables that i mention in picture.

Required Items for Project

Detail of the scenario

Developing ERD

Defining at least $7$ Entity

Defining attributes

Defining all necessary relationships $($Identify with matrix diagram$)$

If possible superype$-$subtype, arc and hierarchical structures, nontransferable relationship.

Preparing "table instance chart" to map ERD to DB structure

Writing SQL DDL statements for implementing ERD $($create table, constraints, defining keys: $pks$ and $fks)$

Making Physical Database using APEX

Entering data to the Database

Writing SQL DML Statements to reach information

One statement including subquery

One statement including join

One statement including group by

One statement including date function

One statement including character function

One statement including update

One statement including alter tabl