InterviewLegend

Design a Library System: Classes, Schema & SQL

Sometimes asked
Alex Chen25 min readGuide updated

Deutsche Bank asked this prompt twice. A Graduate Analyst candidate in July 2021 got a 45-minute second technical round that was a complete design of a library management system plus a deep discussion of their resume. A campus candidate in July 2023 got the version above in their second technical round, follow-ups and all. In 2026 an apprenticeship round in Pune asked basic system design questions next to SQL and a project deep dive.

So treat this as a small design with a database at its center. Nobody asks you to scale a college library to millions of users. The interviewer wants to see whether you can turn a familiar place into classes and tables, keep the numbers in those tables honest, and then query what you built. The 2023 follow-ups prove the point. Every one of them is about the schema, and two are plain SQL.

The Deutsche Bank angle
At Deutsche Bank the design question is one slot in a campus technical round that also covers DBMS, OOP and a coding problem. Those rounds run 35 to 60 minutes, so the design gets a slice. Draw the tables fast, say the keys out loud, and leave time for the queries, because schema prompts there keep going into SQL.

Deutsche BankPremium lesson · System design round

The Deutsche Bank design, worked end to end.

  1. Requirements and scopeSystem design
  2. The API and data model
  3. The design, drawn out1 diagram
  4. 5 deep divesWith the tradeoffs
Get the Deutsche Bank questions

$49 a year · all 107 companies · instant access

20,000+ candidate reports

Deutsche Bank interview guide

Know what Deutsche Bank asks before you walk in.

28 coding · 5 system design · 29 behavioral questions

Get Premium$49 a year · Instant access
Or start freeNo card.

Get their questions first.

Had your Deutsche Bank interview?How we research

InterviewLegend is independent and not affiliated with or endorsed by any company it covers.