Subscription and Payment Data Model

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain

Data Modeling

Difficulty

medium

Seniority

L5

Problem

We run an online education marketplace. Two types of users (students and instructors) can subscribe to different plan tiers. Students pay for access; instructors pay for listing and promotion features. Multiple payment methods are supported. Finance needs month-over-month growth reports and outstanding balance tracking. Design the data model, then write the SQL for MoM subscription growth.

Summary

Two user types. Multiple payment methods. One messy billing table.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.