2. A library service wants to create a database to store details of its libraries, books and

borrowers. Details include the following:

A book has a unique ISBN number, a title, one or more authors, the type of books

(composed of Action and Adventure, Classics, Comic Book or Graphic Novel, Detective

and Mystery, and so on). The library service may own several copies of a given book, each

of which is located in one of the service's libraries. A given library contains many books, and

in order to distinguish different copies of the same book a library assigns a different copy-

number to each of its copies of a given book; the price that was paid for each copy is also

recorded. Every library has a unique name, an address (composed of street address, city,

state, and zip), is either a main library or a branch library. A main library may have zero or

more branch libraries and every branch library is a branch of exactly one main library. A

borrower has a name (composed of first name, middle name, and last name), phone,

email, an address (composed of street address (consists of number, street, and

apartment number), city, state, and zip), and a unique ID code. A borrower can have many

books on loan, but each copy of a book can only be on loan to one borrower. A borrower

could borrow the same book on several occasions, but it is assumed that each such loan will

take place on a different date (composed of starting date and expiration date). There is a

waiting list as an attribute of loan for the books already lent. Any borrower on the

waiting list has a high priority to borrow books. A borrower may have one or more

dependents. A dependent has name, sex, date of birth, and the relationship with the

borrower. Any dependent of the borrower can use the borrower's library card to borrow

books. Draw an ER-diagram and mark the key attributes and the relationship (1:1, N:1, 1:N,

or M:N) between each entity on ER diagram.

2. A library service wants to create a database to store details of its libraries, books and borrowers. Details include the following: A book has a unique ISBN number, a title, one or more authors, the type of books (composed of Action and Adventure, Classics, Comic Book or Graphic Novel, Detective and Mystery, and so on). The library service may own several copies of a given book, each of which is located in one of the service's libraries. A given library contains many books, and in order to distinguish different copies of the same book a library assigns a different copy- number to each of its copies of a given book; the price that was paid for each copy is also recorded. Every library has a unique name, an address (composed of street address, city, state, and zip), is either a main library or a branch library. A main library may have zero or more branch libraries and every branch library is a branch of exactly one main library. A borrower has a name (composed of first name, middle name, and last name), phone, email, an address (composed of street address (consists of number, street, and apartment number), city, state, and zip), and a unique ID code. A borrower can have many books on loan, but each copy of a book can only be on loan to one borrower. A borrower could borrow the same book on several occasions, but it is assumed that each such loan will take place on a different date (composed of starting date and expiration date). There is a waiting list as an attribute of loan for the books already lent. Any borrower on the waiting list has a high priority to borrow books. A borrower may have one or more dependents. A dependent has name, sex, date of birth, and the relationship with the borrower. Any dependent of the borrower can use the borrower's library card to borrow books. Draw an ER-diagram and mark the key attributes and the relationship (1:1, N:1, 1:N, or M:N) between each entity on ER diagram. Phone chmal