Round 1: Machine Coding (90 min) Asked to design an in-memory relational data store.

Round 2: Design

Round 3: Hiring Manager

Got rejected in Round 1, though I gave a working solution. The input I took was slightly different from the question statement.

Ques: Implement an in-memory relational data store.

Features:

Create table createTable(tableName, [Column list])

Delete Table

Insert row

• Ability to generate unique ID
• Insert row result should give newly created ID insertRow(tableName, [value list in the same order of table creation])

Update row updateRow(tableName, [map of column name to updated value])

Delete row

• Delete the rows where column matches the given values deleteRow(tableName, [map of column name to delete value])

Indexing logic createIndex()

Assumptions:

• Field type: all strings.