Consider the following subset of relations from the RVH database:

$$ Patients$($pid$,$ name, address, telephone, care$\_$centre$\_$id$)$

$$ Care$\_$centres$($cid$,$ name, location, nurse$\_$charge$\_$id$)$

$$ Treatments$($tid$,$ patient$\_$id$,$ physician$\_$id$,$ treatment$\_$name, date$)$

$$ Nurses$($nid$,$ name, care$\_$centre$\_$id$,$ certificate$\_$type, telephone, salary$)$

$$ Physicians$($phid$,$ name, pager$\_$number, specialization, salary$)$

Use PostgreSQL $($or the DBMS selected for your labs$)$ to complete the following tasks.

$1.$ Create the tables that correspond to these relations in your PostgreSQL database.