Design a table named "customs agencies" with the following fields: name, address, patent number, id_ customs agent. Where customs agent is another table with name and seniority.
Create a function or procedure that allows inserting new agencies and being able to edit an agency giving the ID of the customs agency.
I don't know how to do this: If id exists in parameter we do an update, else we insert new agencies.