Design a sessions table for a medium-traffic web app

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

Domain

Data Modeling

Difficulty

medium

Problem

Design a sessions table for a medium-traffic web app. Choose between INT and BIGINT for each column based on expected data volume. Think about which values might exceed 2 billion over the system lifetime.

Practice This Problem

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