Fundamentals of Database Systems

Create ERD based on the following tables. The underlines attributes are primary keys. The links are connection between primary keys and foreign keys

Book BookID BookName1PublisherName Book Authors BookID Publisher Name Address Phone AuthorName Book Loans BookID Branch ld LibraryBranch Borrower BranchID BranchName Address CardNo Name Address Phone BookCo NoOfCopies