Question: Draw an entity-relational diagram, using UML notation. Relate tables to each other by linking entities with matching Primary/Foreign keys. Make sure your diagram contains entities,

 Draw an entity-relational diagram, using UML notation. Relate tables to each

Draw an entity-relational diagram, using UML notation. Relate tables to each other by linking entities with matching Primary/Foreign keys. Make sure your diagram contains entities, attributes, identifiers, and relationships. Decide on cardinality and participation of each relationship, and display above the line. The following entities form part of a Library database: Book BookCopy coyNo, ISBN, available) Borrower (borrowerNo, borrowerName, borrowerAddress) BookLoan (copyNo, dateOut, dateDue, borrowerNo) (ISBN, title, edition, year) where Book contains details of book titles in the library and the ISBN is the key. BookCopycontains details of the individual copies of books in the library and copyNo is the primary key. ISBN is a foreign key identifying the book title Borrower contains details of library members who can borrow books and borrowerNo is the key. contains details of the book copies that are borrowed by library members and copyNo/dateOut forms the key. borrowerNo is a foreign key identifying the borrower, copyNo is a foreign key identifying the book copy. BookLoan

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!