Re: HTMLDB 10g
From: Ed Prochak <edprochak_at_gmail.com>
Date: 23 Jun 2006 10:55:58 -0700
Message-ID: <1151085358.573191.311400_at_p79g2000cwp.googlegroups.com>
Date: 23 Jun 2006 10:55:58 -0700
Message-ID: <1151085358.573191.311400_at_p79g2000cwp.googlegroups.com>
gazzag wrote:
[]
>
> Many-to-many relationships are resolved by a third table. You need a
> COURSE_TEACHER table, for example. This table would look something
> like:
>
> id Number -- Primary key
not needed
> course_no Number -- Foreign key to COURSE table
> teacher_no Number -- Foreign key to TEACHER table
(course_no, teacher_no PRIMARY KEY)
>
> HTH
>
> -g
Ed Received on Fri Jun 23 2006 - 19:55:58 CEST