ER Diagram




 


The entities which are involved to this system are as follows.

1.    1.Librarian

    Librarian has some tasks like entering the books, entering reader data, editing data of books, charging delay fees, checking the issued books, check whether who owes the books & etc.

 

2.    2.Readers

    The reader has to do some tasks like checking the books that which has borrowed earlier, checking the delay fee, transaction of online payments, changing the data of the profile, donating books and etc.

 

3.    3.Admin

    Admin has some tasks as the librarian has & also removing the books from the stock, checking the payment & changing the payments also, changing the librarian and etc. These are the entities that has this system.

 

 

The attributes which define the entities are as follows. The entity which is books has attributes like name, ID, author, enter date, quantity & etc. And also the entity which is readers has attributes as ID, name, email, password & etc. The supplier has attributes like ID, name =, email, payments. The attributes which re belonged to the entity librarian are ID, name, email & etc. The entity, issued book has attributes as ID, Reader name, Book name, Date issued, Issued by & etc. The payments entity has ID, Payment, region & date as it’s attributes.

The relationship among the entities are as follows. The attribute, name in the entity, books has the relationship between name of the entity, supplier. And also both those attributes has relationship with the attribute, reader name which belongs to book entity.

 Another relationship among the entities are as follows. The attribute, name in the entity, reader has the relationship between reader name of the entity, issued book. And also, both those attributes have relationship with the attribute, reader which belongs to delay fee entity.

 




 

 

Previous Post Next Post