Database Reference
In-Depth Information
• It will be difficult for you to insert, update, and delete data.
There are two common methods that novice and inexperienced developers use in a futile
attempttoaddressthissituation.I'lldemonstratehowyoumightapplythesemethodsusing
the STUDENTS and CLASSES tables in
Figure 10.16
as examples.
Figure 10.16. Structures of the STUDENTS and CLASSES tables
Note
As this example unfolds, keep in mind that every many-to-many relationship you
encounter will exhibit these same issues.
Asyoucansee,thereisnoactualconnectionbetweenthetwotables,soyouhavenowayof
associating records in one table with records in the other table. The first method you might
use to attempt to establish a connection involves taking a field from one table and incor-
porating it a given number of times within the other table. (This approach usually appeals
