I have a fairly interesting problem because I'm a bit stumped on some business process / functional process requirements in order to make my database work.
I'm currently working at an Insurance company, and they have policys that are sold to the customer. The nitty gritty of it all is that I am redesigning the database for the OLTP application. I have most of my relationships taken care of, i.e. how someone in the system will arrive at the rates for the policies (which are dependent on all of those relationship conditions). I seem to get stuck at the following:
Superset to Subset Bandings -> Rates -> Group# -> Terms. To explain, for every banding, there is a $$ Rate Amount. All Rates belong to a specific Group# and those rates can also be affected by which terms are chosen for the policy. I have a multivalued dependent relationship in a table that goes RateID, BandID, GroupID, TermID RateAmount.
I am trying to Normalize this a bit more. Does anybody have any suggestions for splitting up the tables and maintaining the business logic behind it. It's got me slightly stumped and I could use an outside opinion.