Tim Ferguson wrote:
this model has a lot of advantages:
Colours
Description
-----------
Red
White
Blue
Cars
CarNumber Colour
------------------
1024 Red
1045 White
1190 Red
This means that you don't have to make any joins to see what colours
the
cars are.
Just another thought: alarm bells ring in my head when I see a single
column table. That's why my notes say, if the colours rarely change
then just use:
ALTER TABLE Cars ADD car_colour (VARCHAR (20) NOT NULL);
ALTER TABLE Cars ADD CHECK (car_colour IN ('Red', 'White', 'Blue'));
Jamie.
--
|