Read and understand the scenario carefully. The Ryerson Library requires a database to support its activity. There are s

[answerhappygod]

Read and understand the scenario carefully.
The Ryerson Library requires a database to support its activity.There are several branches in the library systems but it onlyhandles books. Each branch obviously retains many book copies. Eachbranch has a unique branch no, a name, a location and a phone #.For each book in its collection it retains an ISBN, Title,Author(s) information and date of publication. Each book is alsoassigned to one or more subject categories. A set of standardsubject categories is stored in the database to be used in membersearches.
Each subject category can be assigned too many books and can beclassified as being of either a major or a minor type for anyparticular book. A book may have one or more authors. Each authoris assigned an author id and also retained is their first and lastname, date of birth and date of death. For each book there may be 1or more physical copies. For each physical copy there is a copynumber assigned for that book and the date the copy was purchased.That copy number is unique within that ISBN for the whole systembut each copy has a "home" branch. Also retained is a status fieldto record special situations such as "M" (missing) or "T" (intransit). Book copies are available for members to borrow.
When a book loan is made from a branch the date loaned and duedate are recorded. When it is returned that date is also recordedas well as any fines accruing. When an outstanding fine on a loanis paid the date of payment is also noted in that loan record. Notjust any current active loans but a history of all past loans needto be kept in the database. A person is a member of the Ryersonlibrary as a whole and may borrow books from any branch. Eachmember of the library has a member id, first and last name,address, email address and phone number. In addition to borrowingbooks members may reserve a book (but not a specific physicalcopy).
When a reservation is made the reservation date is recorded aswell as the branch where the member will pick it up. When a copy ofthe reserved book is available it will be allocated to thereservation and linked to the branch that has been designated forpickup. The member is notified and the notification date is enteredinto the database against the reservation. The member has 5 days topick up the book and check out a loan on the book or thereservation expires and the copy is returned to its home branch.Only active reservations are kept in the database.
A member can also bring in and register their kids as members(under their same memberID account), however this informationrelationship is to be stored in the database (as a recursiverelationship).
1: Construct the Entity RelationshipDiagram (ERD) for the above given scenario. Identify the differententities, the attributes of each entity including the Primary key,and the relationship between the entities. (Note UseOnly Entity Relationship Diagram Software Such as Erwin SoftwarePlease)