Connection Trap

  • Thread starter Thread starter David Johnson
  • Start date Start date
D

David Johnson

Hi,

Does anyone know what a 'Connection Trap' is in databases? I am completely
stuck what this is in a relational database.

Thanks,
David.
 
Hi, David.

I've never heard of a connection trap, but I'll hazard a guess and surmise
that it might be another name for a fan trap. A fan trap is the result of
an improperly designed relational database, in which a tertiary relationship
is built between entities (tables), instead of a binary relationship. One
entity (table) is functionally dependent upon a second entity to bridge the
intended relation to the third entity. This structure results in data
anomolies and compromises data integrity.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top