Loan Application Reporting Schema

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

L4

Problem

We're a lending platform. Customers submit loan applications. Our risk team reviews each application and either approves or declines it. Approved applications may or may not result in funded loans, since the customer must accept the offer. The analytics team needs approval rate breakdowns by customer segment. Design the data model.

Summary

Approved, declined, or pending. Design the tables that say so.

Practice This Problem

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