Design a Hotel Booking Service - System Design Mock Interview (with eBay EM)

[@tryexponent]

Make sure you're interview-ready with Exponent's system design interview prep course: bit.ly/42Wsa3x

[@jonamep]

Its good to remind that the interviewee should be always asking and confirming with the interviewer about the decisions and next steps. You will probably get a better result if you use the interviewer as a partner in the system design.

[@mrinalaich3723]

Interviewer : Let's quickly go through the High Level Design of the major flows. Interviewee: Yes, builds a block and starts writing SQL queries

[@millen_basquiat]

Great episode! I loved seeing how an EM took his time to really dive deep into subjects. It felt like if the interviewer didn't rush him he would've given us a 5h masterclass haha

[@kevinli9331]

This is a BAD example of how you should do a SD interview. No matter how deep you understand how the system work, always start with high level disign and then dive deep. Especially when the interviwer ask you to do so. I am pretty sure the EM candidate in the video has a lot of expierence on this kind of topic, but I think the way he keep talking himself and ignored what the interview told him to do is definitely a red flag for any company's interview.

[@UpBanarasWala]

It is Informative. I wish there were discussions around how the hotel search will work on geo locations and how the data will be partitioned (sharded).

[@tryexponent]

The tool is Whimsical.

[@azam1200]

Do we need to write code in EM roles , I mean is dSA required in EM interviews?

[@adityabvr3178]

Great approach - Liked the way he jotted down the functional & non functional requirements through mind map. Just my opinion, the 5 room types are across the 1 M Hotels, shouldn't be 5M room types. The types remain same so that we can store the room types in enum.

[@CheeseDiablo]

He mentioned that there is an 18TB database but he didn't talk that there would be huge performance issues with that. Also, the inventory table approach is sorta strange - will he populate all the inventories for 10 years forward?

[@mansi_b]

What tool is being used here? This is awesome!!😊

[@prashantsalgaocar]

For the deadlock, a better way would be to provide API to the reservations API which would only be released once the hold on the room is released or that reservation is cancelled. This would prevent double booking using the reservations API as an argument would be the roomType and status of the room. I think the way it is explained in the video with constraints and other Sql statements needs a revisit.

[@Anteater23]

By assigning room numbers at check in instead of at booking, how do you guarantee that customers will be able to have a particular room for their entire stay?

[@ricktastic6]

I got a question: How do you maintain referential integrity across the 2 databases? I'm assuming one database would contain the Hotel table and the other the Inventory and Reservation table, the latter referencing hotel_id in the former.

[@Deepz007]

Very Nice, thanks for sharing!

[@roliagrawal3124]

What about searching of hotels? Should not be using elastic search which is search database that can be optimisation

[@katekho977]

Hm, I don't feel the candidate was confident enough in his proposals. Swinging from one side to another without actually answering interviewer's questions

[@amitsharma928]

Nice session. Which tool are you using to draw?

[@tryexponent]

Hi AmiTech, the tool being used here for drawing is called Whimsical!

[@vladd3172]

Important topic to cover here: payment failures.

[@mahahrishi]

Which platform you are using for system design while mock interview ?

[@th33ng]

Was he hired? Or not

[@RajYadav-fy4lm]

Enjoyed the session, also timestamp helps

[@jojay6472]

Should have gone deeper into Kafka and how orders are managed. Also, one of the biggest thing with hotels is location so he should have gone into that as well.

[@jojay6472]

Also, didn't talk about sharding

[@mansi_b]

@exponent plz let us know the tool he used!!

[@tryexponent]

Hi Mansi! The whiteboard tool he is using is called Whimsical

[@chintanthakker4129]

I won't go for BFF, To solve under fetching and over fetching issue, graphql is much better option instead of building out BFF for each UI. Too much overhead cost and even complicates the system.

[@HisExcellencyAKK]

Seems like he never addressed scalability and availability in the design.

[@myrondai]

I'm curious what this whiteboard tool is.

[@tryexponent]

Hey myrondai! The whiteboard tool is "Whimsical"!

[@myrondai]

@@tryexponent thank you!

[@dezinerg]

What app is the interviewer using?

[@tryexponent]

Hey Lee! The whiteboard app being used here is called Whimsical!

[@rajdave9822]

🎉🎉🎉🎉🎉🎉