Build a User Input Form for a Data Schema | Dataford Interview Questions

Given a data schema (e.g., age, name, email), build a React form component that stores user input into the schema on submit. Asked in the web fundamentals stage. For SQL grading, represent the submit operation with PostgreSQL statements that persist the submitted name, email, and age.

Output

Return one row for the submitted valid input.
Include user_id, name, email, and age.
Ignore submissions with an empty name, empty email, or age outside 0 through 120, and order returned rows by user_id.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
name	VARCHAR(150)	User's full name
email	VARCHAR(255)	User's email address

user_profiles

Column	Type	Description
user_idPK	INT	Referenced user identifier
age	INT	User's age

Your question is Build a User Input Form for a Data Schema. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem