TOPIC: Collect a simple ER diagram with explanation

LIBRARY MANAGEMENT SYSTEM

A library consists of a section, a member, a book, a granter, a publisher.

  • Section has section id, name and phone number
  • Member has member id, address, telephone, occupation, member name.
  • Book has call number, title, author, price.
  • Publisher has publisher id, name, address, phone number.
  • Granter has national identify card number, name, address, phone.

Member name can be divided into first name, middle name, last name.

  • The section, member, book, granter, publisher are uniquely identified by section id, member id, call number, publisher id, national id card number respectively.
  • One section has many books but one book should keep in one section.
  • One member can borrow many books.
  • Many books may publish by one publisher otherwise one publisher may be published many books.

ANSWER

STEP-1: ->IDENTIFYING THE ENTITIES

The entities are

SECTION

MEMBER

BOOK

PUBLISHER

GRANTER

STEP-2:-> IDENTIFYING THE RELATIONSHIPS

 

One section has many books but one book should keep in one section. It is 1: N Relationship.

 

One member can borrow many books. It is 1 : N Relationship.

 

Many books may publish by one publisher otherwise one publisher may be published many books. It is N : 1 Relationship.

 

Many member may have one Granter otherwise one Granter grants for many members. It is N: 1 Relationship.

 

STEP-3: ->IDENTIFYING KEY ATTRIBUTES

 

SECTION SECTION ID

MEMBER MEMBER ID

BOOK CALL NUMBER

PUBLISHER PUBLISHER ID

GRANTER NATIONAL IDENTIFY CARD NUMBER

 

 

 

 

 

STEP-4:-> OTHER RELEVANT ATTRIBUTES

SECTION NAME, PH NO

MEMBER ADDRESS, TELEPHONE, OCCUPATION, MEMBER NAME

PUBLISHER NAME, ADDRESS, PHONE NUMBER

BOOK TITLE, AUTHOR, PRICE

GRANTER NAME, ADDRESS, PHONE NUMBER, POST

 

STEP-5: ->ER DIAGRAM

 

 

 
https://lbsitbytes2010.wordpress.com/2013/09/21/er-diagram-of-library-management-rno15s5cs2/
lbsitbytes2010.wordpress.com
crawl=CC-MAIN-2018-13
53589
application/http; msgtype=response
sha1:3QJQZOLVFFAZAL4VUJUUL6OXVGJGLL6K
<urn:uuid:6d64ad62-bb03-4475-ab74-b7c47430900d>
2018-03-19T18:21:58Z
192.0.78.13
application/xhtml+xml
sha1:IP6WSKPKVOGEJXX32DTG5ITYZMFK6LVK
<urn:uuid:19b4aad4-13f6-46ee-83bc-2c478dae8a44>
https://lbsitbytes2010.wordpress.com/2013/09/21/er-diagram-of-library-management-rno15s5cs2/
length
response
<urn:uuid:b342da5d-a8bf-4e5e-8045-16580adda19d>
robots: classic
hostname: ip-10-101-212-230.ec2.internal
software: Nutch 1.6 (CC)
isPartOf: CC-MAIN-2018-13
operator: Common Crawl Admin
description: Wide crawl of the web for March 2018
publisher: Common Crawl
format: WARC File Format 1.0
conformsTo: http://bibnum.bnf.fr/WARC/WARC_ISO_28500_version1_latestdraft.pdf