Table with a lot of properties columns

Hi everybody,
can anyone suggest me a better sollution to the problem below if any exists?

Let's have a table of CARS. Each car can have a lot of properties - electrical windows, automatic transmission, leather, ... almost 50 of them. Each property can contain true/false value.
I want to search for all cars that have for example 5 properties set to true. Is there a better way than having one column per one property? An array of bits...???

Thanks,
J.

Since these are just boolean properties, a good approach is to represent
them as one column in your table. This wouls also allow for adding any
additional properties without altering the schema. One sample DDL can look
like:

CREATE TABLE Cars (
Car_Identifier INT NOT NULL PRIMARY KEY,
VIN... );

CREATE TABLE Properties (
Property_id INT NOT NULL PRIMARY KEY,
Description VARCHAR(40) NOT NULL ) ;

CREATE TABLE CarProperties (
Car_identifier INT NOT NULL
REFERENCES Cars (Car_identifier)
Property_id INT NOT NULL
REFERENCES Properties (Property_id)
PRIMARY KEY (Car_identifier, Property_id ));

Now you can simply write a SELECT statement joining the CarProperties table
to get the results you want.

--
Anith