Re: many to many relationship
From: Larry Coon <larry_at_assist.org>
Date: Wed, 05 Mar 2003 14:53:38 -0800
Message-ID: <3E667FF2.86B_at_assist.org>
Date: Wed, 05 Mar 2003 14:53:38 -0800
Message-ID: <3E667FF2.86B_at_assist.org>
john wrote:
> hi,
>
> why is it that a many to many relationship should be changed so that a one
> to many table links the two?
>
> i.e.
>
> table M_________M table
>
> becomes:
>
> table M________1 table 1__________M table
>
> i never understood this during my college course, and just wanted to clarify
Modify the schema to reflect this many-to-many relationship (enrollment in courses) without adding a third table. Show the create table and insert statements to reflect the above enrollments with the above students & courses.
Larry Coon
University of California
larry_at_assist.org
and lmcoon_at_home.com
Received on Wed Mar 05 2003 - 23:53:38 CET