Connection Trap

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.
 
6

'69 Camaro

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.)
 
Top