Page $4$ of $4$

Problem $3$:

The following table shows data maintained by the Materials Manager at Ashford Furniture for tracking suppliers for each

material purchased. Following business rules apply:

$$ Each material has one or more suppliers. Each supplier must supply at least one or more items

$$ The unit price of a material could vary from one supplier to another based on negotiations

$$ Terms are negotiated by the company with each supplier and remain the same for all materials they supply