Scribd
Upload
3 views2 pages

University Library Borrowing System Guide

The document outlines a university library book borrowing system, detailing the entities involved such as Students and Books, along with their attributes. It describes the relationships between these entities, emphasizing the tracking of borrowing transactions. The system aims to manage and analyze borrowing activities, ensuring organized records and proper return of library materials.

Uploaded by

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

University Library Borrowing System Guide

The document outlines a university library book borrowing system, detailing the entities involved such as Students and Books, along with their attributes. It describes the relationships between these entities, emphasizing the tracking of borrowing transactions. The system aims to manage and analyze borrowing activities, ensuring organized records and proper return of library materials.

Uploaded by

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

Title: University Library Book Borrowing System.

1. Introduction
This scenario models how a university library system manages its students, books, and the
borrowing of books. It shows the relationship between these entities and the key data stored for
each.

2. Entities and Their Attributes


a) Student
 Student ID (Primary Key)
 Name
 Email
 Department

b) Book
 Book ID (Primary Key)
 Title
 Author
 ISBN
 Category

c) Borrowing
 Borrowing ID (Primary Key)
 Borrow Date
 Return Date

3. Relationships
 A Student can borrow many Books → One-to-Many relationship
 A Book can be borrowed many times → One-to-Many relationship
 The Borrowing entity connects Student and Book through each borrowing transaction

4. Purpose
This system helps manage and track:

 Which student borrowed which book


 When the book was borrowed and returned
 The borrowing history for both students and books

5. Conclusion
The model ensures organized library records and supports the management of books and student
activities related to borrowing. It also makes it easier to analyze borrowing patterns and ensure
proper return of library materials.

You might also like