Please include in your diagram all the notations needed. The number of tables needed in each case should be clearly stated. Four statements describing the ER is needed in all cases except the supertype/subtype relationships.

4) In a manufacturing organization, parts can be either purchased or manufactured parts. Purchased parts have vendors, price and manufactured parts have setup time. All parts have number and name. The organization manufacutres some parts but can opt to buy the same parts in case there is an urgent need.