How to model any DFA using SQL
The Problem This was one of the challenges I had to handle recently. I wanted to model a Definitive Finite Automata (DFA) using SQL. This reminded me of one of the courses I took in my bachelors (+). This is where I understood how to use DFA for a SQL problem which at first, seems unsolvable. Let’s define the problem clearly. Note that this is a real-life business problem. I’m not talking about theory and a made-up problem. ...