the first create table command generates an error because the column prod_id cannot be used in the primary key