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.)
 
You must log in or register to reply here.

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

Similar Threads

Application wide error trap 1
Access 4
How to trap Excel Save from Access 1
Where do I trap error 3044? 6
Is There A Way To Paste Standard Error Trapping Code 1
Error Checking & Break Point Failure 4
Change fonts throughout database 6
error trapping import error 8

Back
Top