Re: A newbie and his first MySQL schema

[Chris Kavanagh]

Rhino wrote:

> The primary key for the intersection table is the COMBINATION of EmpID 
> and
> ProjID! Neither column by itself would make sense as the primary key 
> of the
> table; the EmpID and ProjID need to be combined to form the primary 
> key. It
> is now possible to store as many projects for an employee as you like 
> but no
> way to say that Employee 1 is on Project B *twice*. That's exactly 
> what you
> want.

This info was just what I needed.  Followup question: do I need to 
somehow tell MySQL that this combination is the primary key?

Kind regards,
CK.