Answer the following questions for a simple library application.

The data requirements of the library application are summarized as follows: BOOK entity is identified by BookId, it has title and multiple author names. PUBLISHER entity consists of Name, Address, and Phone attributes. Name is the key for the PUBLISHER.

LIBRARY_BRANCH entity has BranchId as a key and Branchname attribute additionally. BORROWER entity has BrowerId as key and additionally has name, address, phone attributes. Each LIBRARY_BRANCH has one or more copies of the same book. In such a case, noOfCopies attribute needs to be maintained by the relationship. A book is published by only one publisher. A book can be loaned to a borrower at a specific library branch.

(a) Draw an ER diagram for the conceptual schema of the library database application. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.

(b) Map the conceptual schema to logical database schema.