#228 Relational Model for Books and Authors

Companies:

Digitalleague

Themes:

SQLJoinsPractice

There are books with an id, a title, and a list of authors. There are authors with an id, a full name, and the books they wrote. Design a relational data model and write a query that displays all books by the author Ivanov.

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.