Backend · Junior · Theory

What are a primary key and a foreign key? And how would you model a many-to-many relationship, for example students and courses?

~4 min by voice

How to approach it

The interviewer checks basic understanding of the relational model: why primary and foreign keys are needed, how the database enforces data integrity, and whether the candidate can properly normalize a many-to-many relationship through a junction table rather than storing lists of ids in a single column.

Have you seen this question in a real interview?

Answers0

Avg. score—

Strong—

Practiced0

Topics

sql data modeling

Similar questions

What are slowly changing dimensions, SCDs, and what types do you know? Junior A query that used to run in milliseconds now takes seconds after the table grew to tens of millions of rows. How would you investigate, and what can you do about it? Mid-level You join the orders table with the payments table, and the total revenue in the report suddenly grows almost threefold. How would you look for the cause, and how would you fix it? Mid-level You're designing a sales data mart for BI. Would you choose a star or a snowflake schema, and how would you decide what one row in the fact table represents? Mid-level You need to keep a history of changes to customer attributes, such as plan, city and segment, in a data warehouse, loading data incrementally once a day. How would you implement a Type 2 SCD, and what pitfalls have you run into? Senior

Answer by voice

The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.

Best with headphones · ~4 min