Database design-understanding entity relationship diagram

Assignment Help Business Management
Reference no: EM133151367

Database Design and 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.

1. What entities, attributes, and relationships would you include in the data model for this organization?

2. 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?

Reference no: EM133151367

Questions Cloud

Differences between each of these styles of budgeting : Do some research on top down vs bottom up budgeting. In your post describe the differences between each of these styles of budgeting.
Determine his gross earnings per pay period : Question - Alan earns an annual salary of $86,550. Determine his gross earnings per pay period if the payment frequency is monthly
Prepare abc contribution format income statement for may : ABC Co. makes and sells a single product. In May, ABC sold 2,000 units. Prepare ABC contribution format income statement for May
How much should be credited to share premium : Assuming that the convertible bonds were converted on January 1, 2019, how much should be credited to Share Premium from the equity conversion
Database design-understanding entity relationship diagram : You have been asked to create the logical data model for the Golden Eagle Wholesale Golf Distributors.
Explain fixed and flexible budgeting : Explain fixed and flexible budgeting. Provide an example of budgeting for three consecutive periods in which safety margin is included for flexibility.
Calculate the proceeds from issuance : Calculate the proceeds from issuance if the yield rate is 5% and the bond is issued on 1 August 20X4, still with a maturity date of 31 July 2012
Prepare journal entries for speculative forward contract : On March 1, Year 2, the currencies are exchanged when the spot rate is PP1=$0.0220. Prepare journal entries for speculative forward contract
Why would alexis be hesitant to make such a change : Turner Container Company is suffering declining sales of its principal product, Why would Alexis be hesitant to make such a change

Reviews

Write a Review

Business Management Questions & Answers

  Estimate a firm competitive advantages

Define competitive advantage and describe the two approaches used to estimate a firm's competitive advantages.

  The importance of becoming a global citizen

Describe and explain a clear distinction between "globalism" and "globalization" after viewing the video and reading the article.

  Which program do you feel you are strongest

After covering Word, Excel, and PowerPoint. In which program do you feel you are strongest? What do you think you could do to bolster your strength in the other

  Calculate the cost of trade credit

The credit terms offered to your firm by a supplier are 2.8/6 net 30. Calculate the cost of trade credit if your firm does not take the discount and pays on day 30.

  Different employment tests that are available

What are some of the strengths and weaknesses of the different employment tests that are available, give details for three different employment tests.

  Summarize the types of organizational structures

Summarize the types of organizational structures and their characteristics managers might consider when assessing how to structure an organization.

  Quantitative and qualitative decision making

Discuss one or several of the themes: the nature of managerial decision making, the steps in the managerial decision making, organizational learning

  Interesting paradox the paradox of thrift

An interesting paradox called the "Paradox of Thrift" arises when households become concern about their future and attempt to increase their saving. As a consequence of such action the overall economy will suffer. Explain. Do you agree with thi..

  Discuss what details can be included in a project

Discuss what details can be included in a project scope, and what items should not be included.

  Categories of compression algorithms

Lossless and lossy are the two (2) universally known categories of compression algorithms. Compare the two (2) categories of algorithms

  Aspect of international risk management for a manager

What do you think is the most important aspect of international risk management for a manager? Why?

  Monitor the ongoing performance of staff

List ten (10) criteria which are often used in performance appraisals in the Travel, Hospitality and Tourism industry that can help you

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd