Multi-Branch Bank Transactions Ledger

Project roadmap

1. 01

   Design the schema

   ~1.5h

   Create accounts, branches, and a transactions table recording transfers between accounts.

2. 02

   Insert sample transaction data

   ~1.5h

   Populate accounts across branches with a history of deposits, withdrawals, and transfers.

3. 03

   Compute running balances

   ~2h

   Use a window function to reconstruct each account's running balance over time.

4. 04

   Detect rapid-transfer patterns

   ~2h

   Write a query flagging accounts with multiple transfers within a short time window.

5. 05

   Add balance constraints

   ~1h

   Add CHECK constraints preventing account balances from going negative.

6. 06

   Report branch daily summaries

   ~1.5h

   Write a query summarizing total deposits and withdrawals per branch per day.

Resources

• DocsPostgreSQL Documentation