Skip to main content

Variant 1: Database "Library Management System"

info

Level: Easy

Description​

Design a database for a local library that manages books, members, and borrowing operations.

  • Each book has a title, authors, ISBN, publication year, and category (fiction, non-fiction, etc.).
  • Library members can borrow books for a specific period.
  • Members can leave reviews and ratings for books they've read.
  • The library tracks book inventory and manages multiple copies of popular books.
  • Members can reserve books that are currently borrowed

MVP Features​

  • Basic book management (title, authors, ISBN, publication year)
  • Member management
  • Simple borrowing operations (check-out and return)
  • Basic inventory tracking

Final Version Features​

  • Book categories and classification system
  • Member reviews and ratings for books
  • Book reservation system
  • Multiple copies management
  • Reading history tracking

Technical overview​

Minimal Set of Base Tables:

MVP Tables:

  • Members
  • Books
  • Borrowings

Final Version Tables:

  • Reviews
  • Reservations
  • BookCopies

Minimum Set of Table Fields:

MVP Fields:

  • Member ID
  • Member name
  • Member contact information
  • Book title
  • Book ISBN
  • Borrowing date
  • Due date
  • Return date

Final Version Fields:

  • Book category
  • Publication year
  • Review text
  • Rating (1-5)
  • Reservation date
  • Reservation status
  • Copy status
  • Reading history