Many-to-many relationships will inevitably generate intermediate tables.
Your borrowing record table is the middle table, because the relationship between students and books is many-to-many (note that it is not one-to-many, because a book can be borrowed by multiple students, although it will not be borrowed at the same time, the borrowing record will be saved in the table, which is many-to-many from the database point of view).