supertype/ subtype

[xsnox]

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_part........ with fields.......M-part_no, routing_no
t3 Purchased_part .........with fields........P_part_no, purchase_date
t4 supplies..........with fields.......P_part_no,Supplier_ID, unit_price
t5 Supplier........with fields......Supplier_id, Supplier_name

the supertype is the Parts and the subtype is Manufactured part and Purchased part