Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Intersection between a table of codes and a mystery tabl
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00187443
Message ID:
00187453
Views:
18
Carl,

Using one intersection table is violating relational design pricniples. An entity in relational desing is a person, place, thing, or concept about which we must record information. The intersecting table is a concept of one table (A) being related to another (Codes). Whenyou try to make the intersecting table relate more than two tables (a,B to codes) you are overloading the intersecting table.

This does not mean that you can't make it work, it only means that it is not the simplest design for the problem.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform