Design a schema for a car-engine problem statement and normalize to 3NF
Filed under IDFC First Bank
The question
The candidate was given a car-engine problem statement and asked to design a schema, explain when SQL or NoSQL would be more optimal, write queries for both on large datasets, and normalize the schema to third normal form.
No write-up yet. Related questions below have one.
Collected from public candidate posts and coding forums. Updated Nov 2026.