Re: Simple database design question
From: paul c <toledobythesea_at_oohay.ac>
Date: Tue, 30 Sep 2008 22:08:28 GMT
Message-ID: <wrxEk.50$wq4.11_at_edtnps83>
Date: Tue, 30 Sep 2008 22:08:28 GMT
Message-ID: <wrxEk.50$wq4.11_at_edtnps83>
marks_at_alienmuppet.com wrote:
...
> Sorry, I have missed out some important information:
>
> PHONE:
> phone_id (PK)
>
> SIM:
> sim_id (PK)
>
> RELATION:
> phone_id
> sim_id
>
> unique index on phone_id, sim_id
>
> So now I've got a couple of primary keys as well as the compound
> index..
>
PMFJI, but don't you mean two unique indexes for RELATION, one on phone_id and one on sim_id? (I gather that the typical sql dbms doesn't support candidate keys, so one must use physical features if one wants to minimize the number of tables.) Received on Wed Oct 01 2008 - 00:08:28 CEST