Round 1 (Technical Interview)
Questions:
-
Design a database schema for the following problem statement:
- Composition: Paracetamol (500 MG) + Deca (5 MMG)
- Molecule: Paracetamol + Deca
- Ingredients: Paracetamol, Deca
- Strength: 500, 5
- Unit: MG, MMG
- RxRequired: True (boolean)
Explanation for the problem statement:
- Composition: Contains the details of Ingredients, Strength, and its unit.
- Molecule: Combination of one or more ingredients.
- Ingredients: Names of the ingredients to be used in the molecule.
- Strength: For each ingredient, we will get some number.
- Unit: Unit to be taken for medicine.
- RxRequired: Boolean type (True or False).
After the table was created, I was supposed to write a query to:
- Select all molecules with ingredients “Paracetamol” and with strength 500.
Candidate's Approach
I was able to create the tables and mappings, but the interviewer was confusing at times, which hindered my ability to complete the schema design and write the query.
Interviewer's Feedback
No feedback provided.