What's wrong with my code?

I am working in postgres and keep getting errors when I try to insert data. Please help.

$3.$ Create a trigger function on the CUSTOMER table called reset$\_$password$()$ that will set the Password column to the word $$RESET$$ when a new row is inserted into the table. Create a trigger to use the trigger function. Then, insert a new row into CUSTOMER with the following values:

Customer$\_$id: $($do NOT include the customer$\_$id on the insert. It will be updated automatically$).$

Email$\_$address: your own email address

Password: $$NewPass$$

First$\_$name: your first name

Last$\_$name: your last name

Shipping$\_$address$\_$id: $515$

Billing$\_$address$\_$id: $515$

After the insert, do: $$select $*$ from customer where email$\_$address $=,$ replacing with the email that you entered above, and screenshot the resulting row showing that the trigger worked correctly $($the Password column should have $$RESET$).$

CREATE OR REPLACE FUNCTION reset$\_$password$()$

RETURNS TRIGGER AS $$

BEGIN

NEW.password :$=$ 'RESET';

RETURN NEW;

END;

$$ LANGUAGE plpgsql;

CREATE TRIGGER reset$\_$password$\_$trigger

BEFORE INSERT ON customer

FOR EACH ROW

EXECUTE FUNCTION reset$\_$password$()$;

Insert into CUSTOMER $($email$\_$address, password, first$\_$name, last$\_$name, shipping$\_$address$\_$id$,$ billing$\_$address$\_$id$)$

values $(\text{'}$xxxxxxxxxxxxxxx$\text{'},$ 'NewPass', $\text{'}$xxx$\text{'},\text{'}$xxxx$\text{'},515,515)$;

Select $*$ from customer

where email$\_$address $=\text{'}$xxxxxxxxxxx$\text{'}$;

ERROR: Key $($shipping$\_$address$\_$id$)=(515)$ is not present in table "address".insert or update on table "customer" violates foreign key constraint "customer$\_$shipping$\_$address$\_$id$\_$fkey"

ERROR: insert or update on table "customer" violates foreign key constraint "customer$\_$shipping$\_$address$\_$id$\_$fkey"

SQL state: $23503$

Detail: Key $($shipping$\_$address$\_$id$)=(515)$ is not present in table "address".