Seotion D $-$ Relational Algebra $(5$ points$)$

Refer to the folowing relational schems for the folowing auestions

Doctor $($d$\_$id$,$ d$\_$name, specialty, c$\_$id$)$

Clinic $($c$\_$id$,$ e$\_$name, Director$\_$id$,$ Budget$)$

Patient $(0\_$id$,$ Pname, age, c$\_$id$)$

Examine $($R$\_$id$.d$ id$.$ date, time$)$

White queries using Relational Alzebra operations $($using the operators $($select$),($project$),*$

$($natural join$),$ and $(F)$ aggregate functions$)$ to answer each of the following questions.

Find the name of the doctors who examined the patient with the id $"$P$100".$

List the name of the doctors and the name of the clinic each doctor works on$.$

Find the total budget of each clinic

List patients under the age of $15,$ along with the names of their assigned clinics.

Find the id of the doctors who did not examine any patient.