Have a question on how to connect tables. if I have a CUSTOMER table (with custid as primary key) and a BANK_ACCOUNT table (with accountid as primary key). To connect them together, we have at least two options:
put accountid into CUSTOMER table as a foreign key
put custid into BANK_ACCOUNT table as a foreign key
to me option 2 may be better because it can handle one customer has more than one account case. But how about if that account is a shared account which shared by a hushand and wife, and the husband and wife are separated customer in this system? Then we need another table in between to resolve this?
What's your opinon? do we have general rules for those cases?