System Design - Reservation Booking System | SWE Interview #15

Описание

Most system design interviews involve drawing diagrams to illustrate different components that comprise an entire system. In this interview, however, the entire design of the system is conducted within a Google Doc. The format of a system design interview is typically dictated by the interviewer, but the candidate is sometimes given the option to propose another application to display their design.

The focus of this interview is to design a reservation booking system. The candidate asks several clarifying questions at the outset to better understand the scope and functional requirements of the system. They agree on the use cases, average inputs to the system, constraints, and usage patterns.

The candidate then moves to outlining their high-level design. They start with mocking out the client, the connection to the web server, and then the individual API methods and services that will be called.

To dig deeper into the design, the candidate then writes out the expected data model — the different tables and fields to be stored in the database. Finally, they wrap up with mocking out a particular API method to get the current availabilities for the reservation system.

This video is a short snippet of a longer system design interview. Stay tuned for the full video!

Chapters:
0:00 Problem Statement
0:29 Use Cases
2:42 Estimations
3:29 Constraints
4:04 Usage Patterns
6:18 High Level Design
6:40 API Methods and Services
8:32 User Story
9:17 Mocking out System Design
11:58 Data Model
15:53 API Algorithm Design

If you like the video, please like and subscribe to the channel! If you want to see an interview exploring a particular topic or question, please comment below!


#systemdesign #googledocs #api #datamodeling