Given the requirement to develop a survey page for many users, how would you design the database and UI?

Question

Accepted Answer

Designing a survey page involves creating a user-friendly UI and a robust database schema to handle responses efficiently.

1. Database Schema: Create tables for Users, Surveys, Questions, and Responses.
2. Users Table: Store user information like user_id, name, and email.
3. Surveys Table: Include survey_id, title, description, and creation date.
4. Questions Table: Link to Surveys with survey_id, include question_text and question_type (e.g., multiple choice, text).
5. Responses Table: Capture user responses with response_id, user_id, question_id, and response_value.
6. UI Design: Use a clean layout with clear navigation, progress indicators, and responsive design for mobile users.
7. Example UI Elements: Dropdowns for multiple-choice questions, text boxes for open-ended questions, and a submit button.

Accepted Answer

First you need to design the UI and create db design and save the data fill by the user and create a report to display how many users has filled the form with response and how many users are pending to fill the form.

Asked in HCLTech

Given the requirement to develop a survey page for many users, how would you design the database and UI?

Top Technical Manager Interview Questions Asked at HCLTech

Interview Questions Asked to Technical Manager at Other Companies