Your question is Database design for canteen management. 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).
Design a database for a canteen management system.
Asked in the Technical interview 2 stage. The interviewer cross-questioned the candidate and suggested changes during the discussion.
Explain your schema, relationships, key queries, transaction boundaries, indexing strategy, and approach to concurrency, security, backups, and future reporting or ML use cases.