Hi, Thanks for the response.

In the relationship between Payment and Payment_Type tables, aren't the crows feet backwards?

I see your design i think between Payment and CCD_Details. That is basically a subtype/SuperType. I tried something like that but assumed since i could not create a table with cash maybe that would not be the best design. I like what you did with Payment_Type. I thought of that too. But i never thought of mixing the two.

With Payment and CCD_Details the PaymentID is the primary key in Payment and the primary key in CCD_Details.

It seems as I think this through that CustomerCreditCard will have to have a relationship with CCD_Details with an additional CustomerCreditCardID in the CCD_Details table. So CCD_Details will have CustomerCreditCardID and PaymentID.

CustomerCreditCard and CCD_Details will be one to many. a CreditCard have have many Details or Payments but the Details can refer to only one Credit Card.

Could the CCD_Details table be changed to CCD_Payments?

Let me know. But i think this will work.