Library_Management_System

This is a Library Management Application where a user will be able to borrow books and can also return it. If a user is using a certain book then it will be available to the other user only after the first user returns it.

Features

Add User
Borrow Book
Return Book

Tech Stack

SPRING BOOT
SPRING DATA JPA
SPRING BOOT DEVTOOLS
MySQL DATABASE

ASSUMPTIONS

Fine_Per_Day = Rs 2.
User should return the book within five days.

FLOW

ADD USERS IN THE DATABASE.
ADD BOOKS IN THE DATABASE.
BORROW BOOKS FOR A USER.USER CAN HAVE ATMOST FIVE BOOKS.
RETURN BOOK WITHIN FIVE DAYS OTHERWISE GIVE FINE OF RS 2 PER DAY.

DATABASE DETAILS

I have used port 8320 , and the name of my database is "Library" with three tables namely - book , user , user_borrowed_books .

QUERIES TO INSERT BOOK DATA IN DATABASE

insert into  Book(book_id,author,title,borrowing_amount,is_issued,issued_date,return_date) values(1,'premchand','IdGah',120,false,null,null);
insert into  Book(book_id,author,title,borrowing_amount,is_issued,issued_date,return_date) values(2,'jayshankar Prasad','Ansu',100,false,null,null);
insert into  Book(book_id,author,title,borrowing_amount,is_issued,issued_date,return_date) values(3,'Hariwans rai bacchan','Madhusala',120,false,null,null);
insert into  Book(book_id,author,title,borrowing_amount,is_issued,issued_date,return_date) values(4,'APJ','Ignited Minds',124,false,null,null);
insert into  Book(book_id,author,title,borrowing_amount,is_issued,issued_date,return_date) values(5,'Rs Agarwal','Quantative maths',180,false,null,null);

API Reference

Borrow Book

  borrowBook/{bookId}/{userId}

| Parameter | Type | Description |

| :-------- | : --------- | :-------------- |

| bookId | Integer | Required. |

| userId | Integer | Required. |

Return Book

  returnBook/{bookId}/{userId}