you have been asked to create the logic data model for the golden eagle wholesale golf distributors. golden eagle distributes gold equipment for various manufacturers to the pro shops at golf courses throughout the state. they store the equipment in a centrally located warehouse and ship to the pro shops based on the purchase orders submitted by their sales staff or that are phoned in directly by their customers. if an order is phoned in by the customer, the sales rep is still credited with the commission. since this a wholesale distributor, there is no sales tax charged to the customer. each sales rep is assigned to golf courses within a specific area of the state. you have completed the information gathering phones and are ready to begin designing a database.

your findings indicate that golden eagle must have the following information:

attribute list

equipment cost

equipment selling price

equipment type

golf course address, location, name, phone number, pro shop contact

items ordered

manufacturer name

price of each item ordered

purchase order date

purchase order number

quantity on hand

quantity ordered for each item

reorder point

sale rep responsible for the golf course

sales commission rate

sales rep who wrote the order

sales rep name

shipping date

total amount sure for the order