Design a tiny library database:
books — book_id INTEGER PRIMARY KEY, title VARCHAR NOT NULL, isbn VARCHAR UNIQUE, copies INTEGER DEFAULT 1 (never negative)members — member_id INTEGER PRIMARY KEY, name VARCHAR NOT NULLloans — loan_id INTEGER PRIMARY KEY, book_id and member_id (both required, both foreign keys), issued_on DATE NOT NULL, returned_on DATE that, when present, is not before issued_onThis question starts with an empty database.
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.