If We are testing system which does not have dashboard to display all the stages that are happening in the system, but if we want to write test cases for the module where in we want to test the data flow from table to table is happening or not ?

Do we need to include queries in test case document or not?

How to write test cases for this DB Testing