You are tasked with designing a relational database for a library system in Australia. The library

serves a diverse community and offers a wide range of books, digital media, and other resources.

The library needs an efficient system to manage its collections, track member activity, and

provide valuable services to its patrons.

Requirements:

Entities:

−$-$ Books: Each book has a unique ISBN ($($International Standard Book Number),$),$ title, author($($s),$),$

publication date, and genre.

−$-$ Members: Library members register with their name, contact information, and a unique

member ID.$.$

−$-$ Borrowing Records: Track when a member borrows a book, including the due date for return.

−$-$ Library Staff: Staff members have unique staff IDs, names, roles, and contact information

Answer rating: 100% (QA)

Based on your requirements we can design a relational database with the following entities tables an... View the full answer