Complete an information-level design for Holt Distributors. General description. Holt Distributors buys products from its vendors and sells those products to its customers. The Holt Distributors operation is divided into territories. Each customer is represented by a single sales rep, who must be assigned to the territory in which the customer is located. Although each sales rep is assigned to a single territory, more than one sales rep can be assigned to the same territory.

Question

Business

Amira Ford

22 July, 18:39

Complete an information-level design for Holt Distributors. General description. Holt Distributors buys products from its vendors and sells those products to its customers. The Holt Distributors operation is divided into territories. Each customer is represented by a single sales rep, who must be assigned to the territory in which the customer is located. Although each sales rep is assigned to a single territory, more than one sales rep can be assigned to the same territory.

+3

Answers (1)

Know the Answer?

Terrell Ellison · Answer 1

Here are some changes to the textbook requirements that will simplify your work somewhat.

· The transaction requirements give you information on required tables. (page 339-340)

· Assume that ALL orders ship entirely, in other words there are no partial shipments. Either they ship the entire order or they wait until they have all the required units and then ship.

· Do not include the Customer PO information