MySQL

We have the following two tables.

CREATE TABLE library (

CheckoutID INT PRIMARY KEY,

MemberID INT NOT NULL,

DueDate DATE NOT NULL,

ReturnDate DATE NOT NULL);

CREATE TABLE late (

CheckoutID INT PRIMARY KEY,

NumDays INT);

Write a trigger such that whenever a row is inserted into the library table, check the DueDate and ReturnDate. If the ReturnDate is later than the DueDate, insert a row into the late table with the CheckoutID and NumDays as the number of days late.