Re: Question about relationship and composite pk

On Mon, 19 Mar 2001 21:36:48 GMT, "For example: John Smith" <f_at_r.c> wrote:
>Is it possible for a 1 to many relationship to have (1,1) Cardinality on
>both sides of the relationship?
>
>Are composite primary keys a bad thing? The table I have consists of only
>the two attributes which ocur many times, but only together once.

It sounds like you're describing an association table.

Student Table, pk=name

Smith, Geography
Smith, Math
Jones, Geography

J. Received on Tue Mar 20 2001 - 02:19:45 CET