$1.$ Create database on Pharmacy

$2.$ Identify what the organization does in relation to healthcare and business rules that guide their 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 retrieve this data.

$7.$ Any challenges encountered during database design.

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