Bird
Raised Fist0

A library system uses a single database table for books. Which design improvement helps scale CRUD operations as the number of books grows?

hard📝 Trade-off Q9 of Q15
LLD - Design — Library Management System
A library system uses a single database table for books. Which design improvement helps scale CRUD operations as the number of books grows?
AAdding indexes on frequently searched fields like title and author
BStoring all book data in a single large text field
CDeleting old books instead of archiving them
DUsing a single-threaded server to handle all requests
Step-by-Step Solution
Solution:

  1. Step 1: Identify scaling needs for CRUD

    As data grows, searching and updating must remain efficient.

  2. Step 2: Evaluate design options

    Indexes speed up searches and updates on key fields, improving scalability.

  3. Final Answer:

    Adding indexes on frequently searched fields like title and author -> Option A

  4. Quick Check:

    Indexes improve CRUD scalability [OK]
Quick Trick: Indexes speed up data retrieval and updates [OK]
Common Mistakes:
MISTAKES
  • Using large text fields slows queries
  • Deleting data reduces history
  • Single-threaded limits performance

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More LLD Quizzes
Behavioral Design Patterns — Part 1 - Observer pattern - Quiz 12easy Behavioral Design Patterns — Part 1 - Strategy pattern - Quiz 2easy Behavioral Design Patterns — Part 2 - Mediator pattern - Quiz 4medium Design — Elevator System - Multiple elevator coordination - Quiz 13medium Design — Library Management System - Reservation and hold system - Quiz 3easy Design — Library Management System - Requirements and use cases - Quiz 6medium Design — Parking Lot System - Why parking lot is a classic LLD problem - Quiz 6medium Design — Tic-Tac-Toe Game - Board, Player, Game classes - Quiz 6medium Design — Tic-Tac-Toe Game - Win condition checking - Quiz 9hard Design — Tic-Tac-Toe Game - Why game design tests model-view separation - Quiz 5medium