A patient can schedule appointments with many different doctors. A doctor schedules appointment for many different patients. A patient to schedule an appointment with a doctor need to first get a referral from a primary doctor. Doctors prescribes drugs to patients. A doctor belongs to one Department and a department can have many doctors. A nurse also belongs to one department and a department can have many nurses. In additional, Gate Way to Heaven needs to answer the following functions:

$1)$ List doctor information $($name$,$ email, phone, salary$)$

$2)$ List patient information $($name$,$ age, phone, primary doctor$)$

$3)$ List all prescriptions $($with date, doctor and patient info$)$ that a specific patient receive.

$4)$ List name of all all doctors in a specific department

$5)$ Add a new drug

$6)$ Add a new department

$7)$ Hire a doctor

$8)$ Hire a nurse$$

$9)$ List all appointments a specific patient made

Complete a Crud matrix that has the following scenario:

Write Prescription Reads from Doctors table, Reads and Updates the Drugs table, Reads from Patient table, Creates Reads, Updates and Deletes from Prescription table.

View Patient information Reads from Patients table.

View Doctors information Reads from Doctors table

Manage Drugs Creates, Reads $,$ Updates and Reads information from the Drugs table.