Table creation for books homework

CREATE TABLE book (
    b_no NUMBER PRIMARY KEY,
    title VARCHAR2(25),
    no_of_books NUMBER
);

CREATE TABLE member (
    m_id NUMBER PRIMARY KEY,
    name VARCHAR2(25),
    mobile NUMBER
);

CREATE TABLE borrow (
    m_id NUMBER,
    b_no NUMBER,
    b_date DATE,
    r_date DATE,
    foreign KEY(b_no) references book (b_no),
    foreign KEY(m_id) references member (m_id),
    PRIMARY KEY (m_id, b_no, b_date)
);

INSERT ALL
INTO book VALUES(1, 'db', 2)
INTO book VALUES(2, 'c++', 5)
INTO book VALUES(3, 'java', 7)
SELECT * FROM dual;

INSERT ALL
INTO member VALUES(1, 'Abdullah', 055555)
INTO member VALUES(2, 'Ahmed', 054444)
INTO member VALUES(3, 'Abdulkarim', 059999)
SELECT * FROM dual;