PLSQL program to remove rows from table with conition

I have the following tables:

Resident=(resident_id (PK), resident_name)
Requiest_for_repair=(request_id (PK), Total_cost,reuest_date)
Party_room=(resident_id (PK), start_date, Total_cost)
Event=(Event_id (PK), category, start_date)
Unit_for_sale_lease=(resident_id (PK), Appt_no (PK), Start_date)
Filerequest(resident_id (FK),request_id (FK))

Here is the requirement:

Write a PLSQL program to remove part_room schedule, an event, request for repair, or unit for sale or lease from DB.

In case of party room or repair schedule, provide resident_name, total_cost apply.