Scribd
Upload
18 views4 pages

1RF24CS402,1RF24CS401,1RF24CS403

The document presents an Entity-Relationship (ER) diagram for a Library Management System as part of a DBMS assignment for a Bachelor of Engineering in Computer Science and Engineering. It outlines various entities such as Member, Book, Publisher, and Supplier, along with their relationships and cardinality ratios. The diagram was created using Draw.io and includes details on primary and foreign keys.

Uploaded by

rvit24bcs412.rvitm
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
18 views4 pages

1RF24CS402,1RF24CS401,1RF24CS403

The document presents an Entity-Relationship (ER) diagram for a Library Management System as part of a DBMS assignment for a Bachelor of Engineering in Computer Science and Engineering. It outlines various entities such as Member, Book, Publisher, and Supplier, along with their relationships and cardinality ratios. The diagram was created using Draw.io and includes details on primary and foreign keys.

Uploaded by

rvit24bcs412.rvitm
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

VISVESVARAYA TECHNOLOGICAL UNIVERSITY

“Jnana Sangama”, Belagavi, Karnataka

A Project On
“ER Diagram for Library Management System”

Submitted in partial fulfilment for Assignment

In

“DBMS”

of
BACHELOR OF ENGINEERING

In

COMPUTER SCIENCE AND ENGINEERING

Submitted by

Abhishek Lalu Rathod(1RF24CS401)


Adarsha A M(1RF24CS402)
Amoghavarsha U A(1RF24CS403)

RV INSTITUTE OF TECHNOLOGY AND MANAGEMENT®


(Affiliated to Visvesvaraya Technological University, Belagavi & Approved by AICTE, New Delhi)
Chaitanya Layout, JP Nagar 8th Phase, Kothanur, Bengaluru-560076
2025-26
Library Management System – ER Diagram

Tool Used:
Draw.io (diagrams.net)
Terms Used in the ER Diagram:
* Primary Keys are underlined in the diagram.
* Foreign Keys (which reference Primary Keys) are written in normal text.
Relationship Type and Its Degree:
1. Member borrows Book
• Entities:
o Member (Member ID, Name, Email, Phone, Address)

o Borrow (Borrow ID, Member ID (foreign key), Book ID (foreign key), Borrow
Date, Return Date, Status)

o Book (Book ID, Title, Author, Publisher ID (foreign key))

• Degree: Binary
• Type: One-to-Many
2. Book is published by Publisher
• Entities:
o Book (Book ID, Title, Author, Publisher ID (foreign key))

o Publisher (Publisher ID, Name, Address)

• Degree: Binary
• Type: Many-to-One
3. Book is supplied by Supplier
• Entities:
o Book (Book ID, Title, Author, Publisher ID (foreign key))

o Supplier (Supplier ID, Name, Contact, Address)

o Supplies (Supplier ID (foreign key), Book ID (foreign key), Quantity, Supply Date)

• Degree: Binary
• Type: Many-to-Many
4. Member makes Borrow Transaction
• Entities:
o Member (Member ID, Name, Email, Phone, Address)

o Borrow (Borrow ID, Member ID (foreign key), Book ID (foreign key), Borrow
Date, Return Date, Status)
• Degree: Binary
• Type: One-to-Many
5. Supplier provides Book to Library
• Entities:
o Supplier (Supplier ID, Name, Contact, Address)

o Supplies (Supplier ID (foreign key), Book ID (foreign key), Quantity, Supply Date)
o
• Degree: Binary
• Type: Many-to-Many
Cardinality Ratio:
• A member can borrow multiple books (1:N).

• A book is published by one publisher, but a publisher can publish multiple books (M:1).

• A supplier can supply multiple books, and a book can be supplied by multiple suppliers
(M:M).

You might also like