create table with primary and foreign key

pre: honeywell sensotec pressure transducers
next: gene cancer