BIE-TJV_LIBRARY

LIBRARY DATABASE

ENTITITES
1. BOOKS
2. Author
3. Borrower

Books have attributes :- id, name, author, borrowers Author have attributes :- id, name Reader has attributes :- id, firstname, lastName, books_borrowed

RELATIONSHIPS

1. m:n relationship between Books and Readers.
2. m:1 relationship between Books and Author.
3. 1:m relationship between Author and Books. COMPLEX QUERY Get the reader who borrowed most books.
   BUSINESS LOGIC A reader can borrow a maximum of 5 books, if he wants to borrow more than 5 books. a membership alert will be thrown if he needs more book.

** WORKING ** > We add a book, with the author in it, or add a author and then join boook and author. > We create a reader, and then update the reader with the id of the book it wants.

To try the Application:- *RUN THE APPLICATION ON JAVA JDK 17, > Access the server on http://localhost:8080

     > Access the client on http://localhost:9090
           >> You can go on the browser and ADD BOOKS/READERS 
           and then add a book to the reader.

     > For more, check out the documentaion:-
        http://localhost:8080/swagger-ui/index.html#/