Thread: Two tables
View Single Post
  #5  
Old August 20th, 2007, 11:17 AM posted to microsoft.public.access.tablesdbdesign
Jamie Collins
external usenet poster
 
Posts: 1,705
Default Two tables

On 16 Aug, 13:41, Jason Lepack wrote:
In my limited banking experience I don't have a relationship directly
with a bank.

I have multiple bank accounts, at multiple banks. My bank accounts
are related to the bank, I am related to the bank account.


The person:bank relationship is indirect; there's no reason why the OP
can't abstract the relationship to make it direct. We have an app
where this is done i.e. models the relationship between client and
bank where account details are unknown, undisclosed, etc; we certainly
wouldn't want to be in the situation where this information is lost
because it cannot be entered into the database due to use making the
account entity a prerequisite ('update anomaly' normalization issue).

Jamie.

--