I am having trouble thinking of an effective way to design this (i'm an amateur) particular system, so I am looking for some ideas and/or direction.
I have a database of high risk customers that have been identified, who will be subject to a monthly review.
So i will customers that are being periodiclly being subject to review as new high risk customers are identified and also client will no longer be subject for review because either they close their accounts or it is determined they are no longer high risk.
This database will be used to conduct a monthly review of these high risk customers. For review purposes, it needs to work in such a way that a manager can go back and pull reports pertaining who was subject to a review during a particular timeframe and determine if all necessary reviews were conducted and if it was accurate etc.
I can create everything, it is more of needing help thinking out the design, if I need to have multiple tables, how to link, etc.
Any thoughts?