Simple database design question

#71

marks (AT) alienmuppet (DOT) com wrote:
....

Quote:

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.)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Simple database design question

comp.databases.theory comp.databases.theory

Re: Simple database design question - 09-30-2008 , 05:08 PM