Untitled

 avatar
unknown
plain_text
5 months ago
339 B
1
Indexable
CREATE TABLE Book_Return (
    Issue_id INT(10) PRIMARY KEY,
    Actual_date_of_return DATE,
    Late_days INT(10),
    Late_fee INT(10),
    FOREIGN KEY (Issue_id) REFERENCES Book_Issue (Issue_id)
);

CREATE TABLE Late_Fee_Rule (
    From_days INT(5),
    To_days INT(5),
    Amount INT(5),
    PRIMARY KEY (From_days, To_days, Amount)
);
Editor is loading...
Leave a Comment