create table ProductType ( ProductTypeID int, ProductTypeName varchar(30), ); insert into ProductType (ProductTypeID, ProductTypeName) values (1, 'ToolA'), (2, 'ToolB'), (3, 'ToolC'); create table ProductColor ( ColorID int, ColorName varchar(30), ); insert into ProductColor (ColorID, ColorName) values (1, 'Black'), (2, 'Silver'), (3, 'Brown'), (4, 'Blue');