View the step-by-step solution to:

Scenario You have been asked to create the logic data model for the Golden Eagle Wholesale Golf Distributors.

A.  Scenario

 

You have been asked to create the logic 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 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. Because this is 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. Golden Eagle must have the following information.

 

Attribute List

Equipment cost

Equipment selling price

Equipment type

Golf Course Address

Golf Course location

Golf Course name

Golf Course Phone number

Golf Course 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 Reps name

Shipping date

Total amount due for the order

 

B.  Tasks:

  1. Given the above scenario, identify the entities and list them at the top of the Entity Attribute Form.
  2. Once you think you have a complete list of entities, complete the Entity Attribute Form by listing each entity in its own row, then place the attributes with its entity. Review to make sure that attributes are nonredundant. (See the sample provided.)
  3. Using the entity-relationship (ER) matrix, define the relationship among entities. (See the sample provided)
  4. Draft ERD. This should be hand drawn and need only list the entity name and the primary verb phrase to describe the relationship.
  5. Identify the cardinality for each relationship and place that on the draft.
  6. Normalize your draft and create the Visio ERD. This drawing must show the Entity Name, primary key, any foreign keys, cardinality, and verb phrase. You must also put in all of the nonkey attributes.  

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question