Payment details of installments of insurance policies

Asked

Viewed 54 times

1

I am finding it difficult to model an "Payment Details" entity, where it contains the numbering of an insurance policy or endorsement, with information such as gross premium payable, IOF, total cost, etc. and more installments, which can be up to 3 times.

My difficulty is just how to model the installment. I would have to have a row for each installment?

The PK of this entity is the numbering of the policy that is unique, but if I split, it will no longer be unique, because I will have repetition.

database modeling table online-payment

  • Did the answer solve your question? Do you think you can accept it? See [tour] if you don’t know how you do it. This would help a lot to indicate that the solution was useful for you. You can also vote on any question or answer you find useful on the entire site (when you have 15 points).

1 answer

1

From what I understand you will have two tables (it is possible that you have others, but not for this part of the problem), one with the general details of the payment and the other for the installments. It has to do otherwise, but it is more advanced and more like optimization and complicated in some systems, so the relational model normalized more bandstand would be like this.

In this table of plots would have a row for each plot. The primary key would consist of the policy number plus an item serial, so the first installment would have the serial 01, the second, 02, and so on. The two fields together always form a single key.

Obviously it will be common to use JOIN to join the two pieces of information.

  • In fact, the details of the "Detail" entity are descended from an entity called "Detail of Mission". What are you suggesting is in the "Detail" entity I perform a JOIN of the "Portion" and "Document(Policy) attributes for the creation of a primary key? Detailsmission Policy (PK) Insurer Process Beginning of Vigencia End of Vigencia Insured Importance(R$) Total Prize Detailspayment Codpayment(JOIN "Document" + Installment)PK Apolice(FK) Installment Total Cost The relationship would be (1,n)

Browser other questions tagged database modeling table online-payment

You are not signed in. Login or sign up in order to post.