E-R diagram of library management system is given:

Books are published by publisher and are borrowed by members of the library .

Books are managed by staffs of the library and are categorized on separate sections .

Each book is uniquely identified by book-id and publisher is identified by pub-id.

Also each member has his /her own unique member-id (M-id).

Staffs are identified by their staff-id and also each section has unique section code.

Each book hasauthor, title and price also.

Each publisher has name and address .All staffs has name ,post and salary .

Each section of the library has number and name. Each member has address, name, membership type  and date of membership.

Books are borrowed on the basis of return date, due date and date of issue.

E-R DIAGRAM

Mapping into relational model

Entities:

Publisher

Pub_id Name Address

Member

M_id M_date M_type mname maddr

Books

Book_id Author Title Price

 

Section

    S-code S-name S-no

Staff

S-id S-name Post Salary

Relationships

Published by:

Book_id Pub_id

Borrow by:

Duedate returndate issuedate Book-id M_id

 

 

Managed by:

S_id Book_id

Categorized by:

S_code Book_id

 

Advertisements