ERD

A product line may be a number of products but each product must belong to exactly one product line.

Customers submit orders for products. Each order is submitted by exactly one customer.

Each order line will only have one product listed on that line. Any product sold by valley furniture may not appear on any order line item or may appear on one or more order lines.

Valley furniture has established various sales territories for its customers. Each customer may do business in any number of these sales territories or may not do business in any territory. A sales territory has one to many customers.

An employee may serve on sales territory but each sales territory is served by one or more employees

A product sold by valley can be composed of more than one type of raw material. A particular raw material such as wooden pegs could be used for different products.

Valley gets its raw material from multiple vendors. More than one vendor can supply the same raw materials.

Valley also wants to track a status for their customers and vendors.