Database Schema Design for Monthly SQL Transactions
Filed under Quikr
The question
Design a database schema to handle multiple SQL tables storing transaction data where each month-year is a separate table, constrained by a webserver memory limit, to efficiently calculate opening and closing balances between arbitrary date ranges.
No write-up yet. Related questions below have one.
Related Quikr questions
Collected from public candidate posts and coding forums. Updated Nov 2026.