uestion One

Library Management System

Scenario: You are tasked with designing a database for a library management system. The system needs to track books, authors, members, and book loans. The requirements are as follows:

$$ Each book has a unique ISBN, title, publication year, and genre. A book can have multiple authors.

$$ Each author has a unique author ID$,$ name, and nationality.

$$ Each member has a unique member ID$,$ name, address, and membership date.

$$ Each loan records the loan of a book to a member and includes the loan date and return date.

$$ Authors can write multiple books, and a book can have multiple authors.

$$ Members can borrow multiple books, but a book can only be borrowed by one member at a time.

Given the scenario above, design the relational schema for the library management system. Identify the tables, their attributes, primary keys, and foreign keys. Explain the constraints you would apply to ensure data integrity