SourceCode(MySQL) : CREATE TABLE Book(BookId INTEGER PRIMARY KEY, Title TEXT, Authors TEXT, Available INTEGER, Genre TEX

[answerhappygod]

SourceCode(MySQL) :
CREATE TABLE Book(BookId INTEGER PRIMARY KEY,
Title TEXT,
Authors TEXT,
Available INTEGER,
Genre TEXT
);
INSERT INTO Book VALUES (1, 'Half Girlfriend', 'Chetan Bhagat', 4,
'Love Story');
SELECT * FROM Book ;
CREATE TABLE Publisher(PubId INTEGER PRIMARY KEY,
Email TEXT,
Name TEXT,
YearOfPublication INTEGER,
BookId INTEGER,
FOREIGN KEY(BookId) REFERENCES Book(BookId)
);
INSERT INTO Publisher VALUES (151, 'demo123gmal.com', 'Karan
Johar', 1999, 1);
SELECT * FROM Publisher ;
CREATE TABLE Librarian(LibId INTEGER PRIMARY KEY,
Name TEXT,
Address TEXT,
Phone TEXT,
BookId INTEGER,
FOREIGN KEY(BookId) REFERENCES Book(BookId)
);
INSERT INTO Librarian VALUES (1111, 'Vikash Soni', 'Delhi',
9876543210, 1);
SELECT * FROM Librarian ;
CREATE TABLE Member(MemberId INTEGER PRIMARY KEY,
Name TEXT,
MemberDate DATE,
Phone TEXT,
LibId INTEGER,
FOREIGN KEY(LibId) REFERENCES Librarian(LibId)
);
INSERT INTO Member VALUES (500, 'Rahul Jaiswal', '1999-08-26',
9988776655, 1111);
SELECT * FROM Member ;
CREATE TABLE Borrow(DateOut DATE,
DueDate DATE,
BookId INTEGER,
MemberId INTEGER,
FOREIGN KEY(BookId) REFERENCES Book(BookId),
FOREIGN KEY(MemberId) REFERENCES Member(MemberId)
);
INSERT INTO Borrow VALUES ('2021-06-01', '2021-07-04', 1,
500);
SELECT * FROM Borrow ;
can you make an interface for the following sql code
using python