anyone??

am trying to create a database (mysql) from a super type subtype relation. my question is how do i create the tables with the right constrain (PK, FK)

here is the proposed tables t

t1 Parts with fields part_no, description, location, manufactured?, purchased?
t2 Manucfatured_pa rt........ with fields.......M-part_no, routing_no
t3 Purchased_part .........with fields........P _part_no,...