Library Management Schema

Design tables for a library: books, members and loans. A member can borrow many books over time and a book can be borrowed by many members. Write the CREATE TABLE statements with keys and constraints.

Table schema

Entities: Book(title, isbn), Member(name, email), Loan(book, member, loan_date, return_date)

Sample data

A member can have many loans and a book appears in many loans.