For the project $($pharmacy database$)$ we need :

$1)$ entity diagram for pfarmacy, created in Oracle tables $($ properly connected $),$ in every table $4$ records added

$2)$list of functionalites

for functionalities we should have queries using:

a$)$connecting tables by:

vertical join

self join,

non equi join

and equi join $($ which is obvious$)$

b$)$ using NVL$(),$ LIKE, IN $,$ ORDER BY$,$ ALL, ANY, EXISTS

c$)$ group functions with conditions having

d$)$ subgueries : corelated and not corelated