Scenario: Library Database You will need to draw out a relational database for this scenario. Make sure you identify the correct one $-$to$-$one, one $$ to $$ many; many $$ to $$ many...... Entities: $1.$ Books: Represents the books available in the library. $2.$ Authors: Represents the authors who write the books. $3.$ Borrowers: Represents the members who borrow books from the library. $4.$ Borrowed Books: Represents the borrowing activity of books by borrowers. Entity Definitions: $1.$ Books Table : What$$s the $($Primary Key$)-$ BookID $-$ Title $-$ PublishedYear $-$ AuthorID $($Foreign Key linking to Authors$)$ Relationship: One book can have one author, but an author can write many books. $2.$ Authors Table : What$$s the $($Primary Key$)-$ AuthorID $-$ Name $-$ DateOfBirth Relationship: Each author can write many books, but a book has only one author. $-3.$ Borrowers Table : What$$s the $($Primary Key$)-$ BorrowerID Name $-$ MembershipDate Relationship: One borrower can borrow many books over time, and each book can be borrowed by different borrowers at different times. $4.$ Borrowed$\_$Books Table $($Join Table for the Many$-$to$-$Many relationship between Borrowers and Books$).$ What$$s the $($Primary Key$)--$ BorrowID $-$ BookID $($Foreign Key linking to Books$)-$ BorrowerID $($Foreign Key linking to Borrowers$)-$ BorrowDate $-$ ReturnDate Relationship: Each record in this table represents a specific borrower borrowing a specific book on a specific date.