You wish to create a trigger on the ‘city’ table that will check the value of the ‘District’ field before any INSERT. The trigger needs to change it to" Unknown" for an empty string or NULL.

CREATE TRIGGER City_bi -

BEFORE INSERT ON CITY -

FOR EACH ROW -

BEGIN -
IF OLD. District IS NULL OR OLD.District= . .

THEN -
SET NEW.District=Unknown;
END IF :
END;
Does the CREATE TRIGGER statement accomplish this goal?