Library Management System

The Library Management System is a robust and efficient application developed using the Spring Boot framework and Hibernate for seamless database interaction. This system empowers librarians with the capability to effortlessly manage the library's collection. Librarians can efficiently add new books to the library database, ensuring accurate and up-to-date records.

Key features of the system include an intuitive user interface for librarians to easily input book details such as title, author, genre, ISBN, and other relevant information. The use of Spring Boot facilitates the creation of a scalable and maintainable system, while Hibernate streamlines the database operations, ensuring data integrity and reliability.

Database

CREATE TABLE IF NOT EXISTS genres (
  id   INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  name varchar(50),
  INDEX (name),
  UNIQUE (name)
);

CREATE TABLE IF NOT EXISTS books (
  id       INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  title    varchar(50) NOT NULL,
  ISBN     varchar(255) NOT NULL,
  genre_id INTEGER UNSIGNED NOT NULL,
  INDEX title_index (title),
  UNIQUE (title, ISBN),
  CONSTRAINT FOREIGN KEY (genre_id) REFERENCES genres(id)
);

CREATE TABLE IF NOT EXISTS authors (
  id         INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  first_name varchar(50) NOT NULL,
  last_name  varchar(50) NOT NULL,
  UNIQUE (first_name, last_name)
);

CREATE TABLE IF NOT EXISTS book_authors (
    book_id    INTEGER UNSIGNED NOT NULL,
    author_id  INTEGER UNSIGNED NOT NULL,
    PRIMARY KEY (book_id, author_id),
    CONSTRAINT FOREIGN KEY (book_id) REFERENCES books(id),
    CONSTRAINT FOREIGN KEY (author_id) REFERENCES authors(id)
);

Roadmap

• Add Error handling
• Finish the REST API for Books
• Add Integration tests with TestContainers
• Start work on the frontend