LLD - Design — Food Delivery System
Which data model is most suitable to store a user's rating and textual review for a product?
Which data model is most suitable to store a user's rating and textual review for a product?
easy🧠 Conceptual Q3 of Q15
Step-by-Step Solution
Solution:
Step 1: Determine required data for each review
Each review needs user ID, product ID, rating value, review text, and time.Step 2: Match data model to these fields
A record with these fields stores all needed info clearly.Final Answer:
A record with fields: user_id, product_id, rating, review_text, timestamp -> Option DQuick Check:
Review data model = Detailed record [OK]
Quick Trick: Store all review details in one structured record [OK]
Common Mistakes:
MISTAKES- Using only product names without review data
- Storing just total counts loses details
- Using boolean flags cannot hold review text
Master "Design — Food Delivery System" in LLD
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore LLD Quizzes