I'm working on some asp.net application, I got stuck in following business.

Suppose we have a person, and he can open both types of accounts and each account has some transaction history. Person table has some primary key say PPK, and customer table has some PK as PIN.

My question is how to solve/present this scenario in database, relation of person table to customer table is 1:2 as no person can have more than two account. and what about that transaction table? that holds all transaction history for some specific account? shall I make two transaction table (which is really a bad idea because as account type exceeds transaction tables exceeds).

Can I build their relation as 1:\* (then I may need another table for that. it holds Fk of both table. )

or Can make pin as unique key and always open database for like checking limit of accounts (i.e. two).

I really need some suggestions.

All suggestions are welcome.

Thanks!

P.S: If you dont understand the question please ask me before reporting it away please!