CREATE TABLE Books (
    ISBN VARCHAR(20) PRIMARY KEY,
    Title VARCHAR(150) NOT NULL,
    Author VARCHAR(100) NOT NULL,
    Genre VARCHAR(50),
    Quantity INT
);


CREATE TABLE Members (
    MemberID INT PRIMARY KEY,
    Name VARCHAR(100) NOT NULL,
    Email VARCHAR(100),
    Phone VARCHAR(20)
);

CREATE TABLE Loans (
    LoanID INT PRIMARY KEY,
    MemberID INT,
    ISBN VARCHAR(20),
    LoanDate DATE,
    ReturnDate DATE,
    FOREIGN KEY (MemberID) REFERENCES Members(MemberID),
    FOREIGN KEY (ISBN) REFERENCES Books(ISBN)
);

CREATE TABLE Authors (
    AuthorID INT PRIMARY KEY,
    Name VARCHAR(100) NOT NULL,
    Nationality VARCHAR(50),
    BirthYear INT
);

INSERT INTO Authors (AuthorID, Name, Nationality, BirthYear)
VALUES
(1, 'Chinua Achebe', 'Nigerian', 1930),
(2, 'Wole Soyinka', 'Nigerian', 1934),
(3, 'J. K. Rowling', 'British', 1965),
(4, 'George Orwell', 'British', 1903),
(5, 'Ngugi wa Thiongo', 'Kenyan', 1938);

SELECT * FROM Authors;