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.

If not automatically created by the DBMS$,$ create indexes corresponding to the primary and foreign keys