Design an ER diagram for a Library book management system. The library

Question

Design an ER diagram for a Library book management system. The library has many books. The library keeps several copies of important books. Each book is identified by a unique identification number. In addition, the library records the ISBN number, title of the book, names of the authors of the book, publisher’s name, and year of publication for the books. The books can be issued to members. A member pays Rs 1000 for yearly membership. Membership is renewed every year. A member can be issued a maximum of 5 books. Identify and list the entities, attributes, relationships, cardinality, keys and constraints. Make and state suitable assumptions.

07 Mar 2024

Answer :

Word Count : 319

Entities:
1. Book
2. Copy
3. Author
4. Publisher
5. Member
6. Membership

Attributes:
Book:
- ID (Primary Key)
- ISBN
- Title
- Year of Publication
- Publisher ID (Foreign Key)
- Author ID (Foreign Key)

Copy:
- Copy ID (Primary Key)
- Book ID (Foreign Key)

Author:
- Author ID (Primary Key)
- Author Name

Publisher:
- Publisher ID ___ __________ _______ _________ _______.
_____ ____ __________ ____ __________.
___ ______ _________ _________ ________ ______ ______ _________ ________ ___ ______.
_____ __________ ____ ___ _______ ____ ____ _______ ________ _____ ___.
___ ___ ______ _______ ________ _________ ___ _________ ____ ________ ________ _________.
________ _____ ____ _______ ______ ___ _____.
_________ ____ ______ __________ ______ _________ ____ ________ _________.
______ _______ ________ ____ ______ ___ ____ ________ _________ ______.
_________ _______ ______ ___ ______ _______ ___ ____ _____ __________.
____ _______ _______ ____ ___ ___ _______ __________ ____.
__________ ___ ______ ______ ________ ______ _________ ___ _________.
_______ ____ ____ ______ ____ _________ __________ _______ __________ ___.
_____ _____ __________ ________ _____.
_______ ______ __________ ______ _________ ___ __________ ______ ________ ____ ______.
______ _________ ___ _________ _________ _______ ________ ______ __________ ______.
__________ __________ ____ ___ _______ _________ ______ ________.
_____ ____ ____ _____ __________ ________ _____ __________.
__________ ___ _____ _______ _____ ____.
____ ________ __________ _____ _________ _________ _________ _________ ___ _______ ________ ____.
_____ ______ _____ ________ _______ ______.
______ ____ ________ _______ ________ ____ ________ ___ _______ __________.
___ ____ ___ ___ ________ ____ ___ ________ _____ ____ __________ _________.
_____ __________ _________ ______ _______ ________ ___.
_________ ______ _________ __________ ___.
______ ______ ___ ___ __________ __________ _______.
____ __________ ______ ___ ___ _______ _____.
______ _______ ________ _____ ___ ____.
_____ _____ ______ ________ ______ ____.
___ _____ ____ _____ _______ _____.
Get Full Answer on WhatsApp

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★