Senior Backend Engineer Interview Questions and Answers

Design a database schema for a movie ticket booking system similar to BookMyShow.

• Create tables for movies, theaters, users, bookings, and seats

• Use foreign keys to establish relationships between tables

• Include columns for movie details, show timings, seat availability, user information, and booking details

• Implement indexes for faster retrieval of data

• Consider implementing a caching mechanism for frequently accessed data