Discussion Post: Database Design & Understanding an Entity Relationship Diagram (ERD)
You have been asked to create the logical data model for the Golden Eagle Wholesale Golf Distributors. Golden Eagle distributes golf 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 ones that are phoned in directly by their customers. Each sales rep is assigned to golf courses within a specific area of the state.
a) What entities, attributes, and relationships would you include in the data model for this organization?
b) You have created an entity relationship diagram (ERD) for an organization's database, and you are preparing to review it with the company's managers to make sure it is complete and correct. The managers do not have technical backgrounds and are unfamiliar with database design. How would you explain the concept of an ERD to these managers to orient them for your review?
The response must include a reference list. Using Times New Roman 12 pnt font, double-space, one-inch margins, and APA style of writing and citations.