MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Bank_operation (
Customer_id INT ,
Date_id date Primary key,
Transaction_amount INT);
CREATE TABLE Rates (
Date_id date Primary key,
Ccy_code INT,
Rate decimal (5,2),
FOREIGN KEY (Date_id)  REFERENCES Bank_operation (Date_id));
INSERT INTO Bank_operation VALUES (123658, '2022-03-12', 6500 );
INSERT INTO Rates VALUES ( '2022-02.21', 230, 70.65 );
Cannot add or update a child row: a foreign key constraint fails (`db_2079783760`.`Rates`, CONSTRAINT `Rates_ibfk_1` FOREIGN KEY (`Date_id`) REFERENCES `Bank_operation` (`Date_id`))

INSERT INTO Rates VALUES ( '2022.05.15', 230, 72.20 );
Cannot add or update a child row: a foreign key constraint fails (`db_2079783760`.`Rates`, CONSTRAINT `Rates_ibfk_1` FOREIGN KEY (`Date_id`) REFERENCES `Bank_operation` (`Date_id`))