System Design Interview Questions
Practice with real System Design interview questions
01
A Full Stack Developer was asked
Asked in 2026
Q. Describe how you would implement a serverless solution for processing video uploads and transcoding in a cloud environment.
Ans. Implementing a serverless solution for video uploads and transcoding can be efficiently done using cloud services like AWS Lambda, S3, and media transcoding services. Here is how you can approach it:
1. File Upload: Set up an S3 bucket to handle video uploads directly from the frontend. The frontend can use presigned URLs to upload files securely.
2. Trigger Lambda Function: Configure the S3 bucket to trigger an AWS Lambda function when a new video is uploaded.
3. Transcoding: Use AWS Elemental MediaConvert or FFmpeg inside the Lambda function to transcode the uploaded video into different formats.
4. Storage of Transcoded Videos: Store the transcoded videos back in S3 or in a different bucket based on the output format.
5. Notify Completion: Optionally, use SNS (Simple Notification Service) to notify other services or users when the transcoding is complete.
Example Code for Lambda Function:
This serverless architecture automatically scales with the number of uploads and minimizes management overhead, as you only pay for the resources consumed during processing.
Full Stack DeveloperCore Concept
02
A Software Engineer was asked
Asked in 2024
Q. Explain the concept of normalization in DBMS and describe the different normal forms with examples.
Ans. Normalization is a database design technique that organizes tables to reduce redundancy and dependency. The different normal forms are: 1. First Normal Form (1NF): A table is in 1NF if it contains only atomic values and each column has unique names. For example, a table of student records should not have multiple values in a single column.
To convert to 1NF, we would split 'Courses' into a separate table:
2. Second Normal Form (2NF): A table is in 2NF if it is in 1NF and all non-key attributes are fully functional dependent on the primary key. For example:
To convert to 2NF, we can move 'ProductName' to a separate table:
3. Third Normal Form (3NF): A table is in 3NF if it is in 2NF and all the attributes are functionally dependent only on the primary key. For example:
To convert to 3NF, we separate the department details:
Normalization helps maintain data integrity and efficiency.
Software EngineerCore Concept
