Re: Question on Structuring Product Attributes

In this particular case, the way to do this in full, repeat FULL Standard SQL, is with global CHECK() check constraints. Make and model information is in the VIN so a regular expression can check it.

CREATE TABLE SUV
(vin CHAR(17) NOT NULL PRIMARY KEY,

    REFERENCES Vehicles (vin),
 CONSTRAINT vin_in_motor_pool

      CHECK (EXISTS
            (SELECT *
               FROM Vehicles AS V1
              WHERE V1.vin = SUV.vin),
 CONSTRAINT suv_vin
      CHECK (<< regular expression >>),