• Because you have made foreign key as MatchID, where as it should be Venue ID.

    CONSTRAINT fk_VenueID FOREIGN KEY (MatchID)

    It should be :-

    CONSTRAINT fk_VenueID FOREIGN KEY (VenueID)

    You create 10 rows for Venue table so after. SO there are 1-10 venue id and when you try to insert 11th row in Match table, you get FK violation error.