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

 

 

 

Advertisements