As the name suggests, this database management system project is related to the storage of information regarding the library. Library is the place with the huge collection of books. It is place from where the students and the faculties issue the books for their reference purposes. But the maintenance of keeping the records of issuing and borrowing is difficult if you use a normal book as a registry. To make this task easier, the library management system database will be very useful. The system design of library management system will provide the design phase for the library management system. The main aim of the design phase is to provide the solution for the specified requirements.
Functional decomposition can be defined as the process of dividing the functional relationship into different parts. This can be resolved later. Modularity must be maintained among the constituent processes. The context flow diagram generalizes the functions of the entire system. A data flow diagram will show the flow of data from the source to the destination. The data flow diagram is the starting step of the design phase and it is a very important to understand the requirements. The descriptions of the components are as follows:
- Register user: A new user can be registered in this component.
- Book issue: Books can be issued to the user and can be added as a record in the database.
- Book return: The books will be returned by the user within the final date.
- Search/View Book details: This component allow to search or view the books. If located in the particular shelf, it can be searched in order to get the exact location of the book.
- Update: The book details can be updated through this component.
- Payment: Manually the payment must be done if the return date exceeds the final date.
CFD of Library Management System:
Level 1 of Library Management System:
Description of component:
Function component 1:
Registration: New user can register.
Input: user details.
Process definition: Processing information and stored in the database.
Output: User details updated in the database.
Function component 2:
Book issue: Here the books will issue to the user.
Input: Book ID.
Process definition: Searching books.
Output: Search and retrieving book information.
Function component 3:
Book return: Here the books will return.
Input: Book ID.
Process definition: Checking book details.
Output: Book is returned.
Function component 4:
Search/view book details: It is used to search and view the details of the book.
Input: Book ID.
Process definition: Searching books.
Output: Details of the book will be shown.
Function component 5:
Update book details: New book entry can be added.
Input: Book ID.
Process definition: Processing the information.
Output: Update in database
Function component 6:
Payment: Here payment is done.
Input: User ID.
Process definition: Checking user account details.
Output: Book will be issued.
Download Source code: