Try to map the relational schema of Figure 1 into an ER diagram. This is part of a process known as reverse engineering, where a conceptual schema is created for an existing implemented database. State any assumptions you make.
BOOK
Book_id Title Publisher_name
BOOK_AUTHORS Book_id Author_name
PUBLISHER Name Address Phone
BOOK_COPIES Book_id Branch_id No_of_copies
BOOK_LOANS
Book_id Branch_id Card_no
Date_out Due_date
LIBRARY_BRANCH
Branch_id
Branch_name
Address
BORROWER
Card_no Name
Address Phone
Figure 1