Revisiting the Brands / Makes question

On a somewhat theoretical note, I'm curious what properties others might
think a Brand might have (or, as noted by Alex P. in response to my earlier
"Simple primary key question", most folks refer to car Brands as "Makes").
It would seem to me that all aspects of the Brand are related to the Model.
So, the Brand table becomes simply a single column, itself the Primary key.Earl wrote:
> On a somewhat theoretical note, I'm curious what properties others
> might think a Brand might have (or, as noted by Alex P. in response
> to my earlier "Simple primary key question", most folks refer to car
> Brands as "Makes"). It would seem to me that all aspects of the Brand
> are related to the Model. So, the Brand table becomes simply a single
> column, itself the Primary key.
A "Make" could have addresses, phone numbers, and parent companies as a
FK associated with them. For example, Saab is a General Motors company
and Volvo is owned by The Ford Motor Company.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||I have a similar situation with another product -- but not quite. The tree
falls like this:
Manufacturers (address, phone, etc.) have Brands which have Products. In
this case, the Brand doesn't have any of the properties (altho it could in
the car scenario), because the Brands are ordered from the Mfr address. But
what I've discovered is that Brands DO have a few characteristics, in my
case, a "primary material" and a pricing multiplier.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:erUQcLG1FHA.1032@.TK2MSFTNGP12.phx.gbl...
> Earl wrote:
> A "Make" could have addresses, phone numbers, and parent companies as a FK
> associated with them. For example, Saab is a General Motors company and
> Volvo is owned by The Ford Motor Company.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com