Draft a project proposal on heathcare $($Pharmacy$)$ with an ERD diagram

Below are the project guidelines:

$1.$ Database that you will be creating is relevant to healthcare: Pharmacy

$2.$ Identify what the organization does in relation to pharmacy and business rules that guide thier operations.

$3.$ Create ER model with entities $($Tables$),$ attributes $($Fields$),$ relationships $(1$:$1,1$:M$,$ M:N$),$ and constraints $($Domain$/$Flags$).$

$4.$ Draw ERD diagram with proper naming convention, arrows, identify Primary Key, Foreign keys and any other keys that you use.

$5.$ Identify there are any super entities, sub entities, and entity clusters.

$5.$ Identify what information needs to be retrieved from the data located in the database you designed.

$6.$ Write SQL statements to retrive this data.

$7.$ Any challenges encountered during datadase design.

$8.$ What kind of security will be given to users to limit access.