UPDATE STORE
SET 
	City = 'NYC'
WHERE 
	City = 'New York City'
;

INSERT INTO SHIPMENT(ShipperID, PurchasingAgentID, ShipperInvoiceNumber, Origin, Destination, ScheduledDepartureDate, ActualDepartureDate, EstimatedArrivalDate)
VALUES('1', '104', '999999', 'DELETE', 'DELETE', '02-Jun-18', '04-Jun-18', '17-Jul-18');

INSERT INTO SHIPMENT_ITEM
VALUES('106', '99', '500', '99');

DELETE FROM SHIPMENT_Item WHERE ShipmentID = '106';
DELETE FROM SHIPMENT WHERE ShipmentID = '106';