I would disagree with the second table, that's a denormalisation and just means you have to maintain checked out books in two places instead of one.

Instead you just need the transactions table with BookID, MemberID, CheckedOutDate and CheckedInDate.

To see checked out books you just look for transactions with a checked out date but no checked in date.