INSTRUCTIONS

Read the TEXT given below and draw an ERD using Visual Paradigm. $[$Like you did in your project$]$

Clearly show the symbols $[$ example: line and crow's feet$]$

Write the Relationships. Example: A SUPPLIER supplies multiple PARTS. This is a One to Many$\_$relationship.

CUSTOMERS place multipple ORDERS. This is a Many to Many relationship.

$4.$ Copy the ERD Screen shot in a Word Document, write the Relationships as explained above and upload that word document in the assignment.

This is an individual assignment.

TEXT:

A Library system needs to manage Books, Authors, and Members.

The relationships are as follows:

A Book can have one or more Authors $($a book might be written by multiple authors, and each author can write multiple books$).$

A Member can borrow many Books, but each Book can be borrowed by multiple Members over time $($many$-$to$-$many relationship$).$

A Member has a Membership, which includes the start and end dates of their membership.

Entities:

Book

Author

Member

Memberships