Loading...
Event Ticketing System Data Model
A easy Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.
- Domain
- Data Modeling
- Difficulty
- easy
- Seniority
- junior, mid
Problem
We run an IT helpdesk platform. Users submit support tickets, which are assigned to agents. Tickets go through multiple status changes before being resolved. SLA compliance is critical: P1 tickets must be resolved within 4 hours, P2 within 24 hours. Design the schema, and describe how you would load data from a JSON API feed into it.
Practice This Problem
Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it instantly.