Design a Library System: Classes, Schema & SQL
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.
Deutsche BankPremium lesson · System design round
The Deutsche Bank design, worked end to end.
- Requirements and scopeSystem design
- The API and data model
- The design, drawn out1 diagram
- 5 deep divesWith the tradeoffs
$49 a year · all 107 companies · instant access
20,000+ candidate reports
Deutsche Bank interview guideKnow what Deutsche Bank asks before you walk in.
28 coding · 5 system design · 29 behavioral questions
Get their questions first.
InterviewLegend is independent and not affiliated with or endorsed by any company it covers.