Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Library Relational Database Design

HardSQL & Data Manipulation00:00
Practice interviewer
In session
5 left
00:00

Your question is Library Relational Database Design. Take a moment with it on the right.

Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).

You need to log in / sign up to chat or submit.

Problem

You are designing a relational database to keep track of a library. Here is some of the information you might be interested in storing: names and addresses of patrons, titles at the library, author information, individual copies of titles, and books that individuals have checked in and checked out with dates and times. How would you design the schema?