1) Users register through a User Interface and subscribe for an alert.. there are subscription types
2) Users can register only to those alerts to which they are entitled for.. i.e there is something called as Entitlements
3) Alerts are provided by various systems example Payments, reports system etc
Ex: if your account balance came to minimum then payment system will send you an alert
4)Alerts are sent through..various channels like :sms,email etc
5)Alerts have alert types ex: payment alerts, report alerts.
I have to model the system for the above scenario...
Question: should there be individual tables for payments and reports etcc or all the information should be in a single table
and what are the tables that we can design here ...
Last edited by rajesh_tns; 03-14-09 at 12:10.
Reason: need to add more information