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