ShipPartCride is a foreign key in the Shipment table. ShipPartCode refers to the primary key PartCode of the Part table. What replaces XXX in the following statement?

CREATE TABLE Shipment $($

ShipNumber INT UNSIGNED,

ShipPartCode CHAR$(3)$ NOT NULL,

Quantity SMALLINT UNSIGNED,

PRIMARY KEY $($ShipNumber$),$

;