Define the APIs expected from the system. This is your chance to analyze and define the read and write paths so that you can come up with the high-level design...
IF alias in ( Select alias from table where url = url) return 1 else 0
if http request=post:
-check if valid input else throw error
-CheckIfExists: if yes return error under form field 'alias already exits. if no: insert into table (url,alias) values (url given and alias given)
Describe the overall system architecture. Identify the main components needed to solve the problem end-to-end. Use the diagramming tool to create a block diagram.
Deep dive into 2-3 key components. Explain how they work, how they scale, discuss tradeoffs, capacity, and any relevant algorithms or data structures.
scaling of database- should use some serverless architecture so they can scale up as new aliases are created