Purchase Solution

Mangement Analysis: Entity Relationship Diagram

Not what you're looking for?

Ask Custom Question

Entity Relationship Diagram (ERD): What is the purpose of ERD? Can you explain using the below scenario? How can this be used to enhance my business?

AlohaPets put on events for local pet owners. The company needs a database designed to keep track of the sponsor for the event and where the event is located. Each event needs a description, data, and cost. Separate costs are negotiated for each event. The company would also like to have a list of potential sponsors that includes each sponsor's contact information, such as the name, phone number and address. Each event will have a single sponsor, but a particular sponsor may sponsor more than one event. Each location will need an ID, contact person, and phone number. A particular event will use only one location, but a location may be used for multiple events.

Purchase this Solution

Solution Summary

The solution discuses the entity relationship diagram in management analysis.

Solution Preview

Entity Relationship Diagram (ERD)
An entity relationship diagram (ERD) is a model that is used in order to presents the logical relationships and interaction among system entities. So the main purpose of building ER-Diagram is to provide an overall view of the system and a blueprint for creating the physical data structure (Shelly, Cashman & Rosenblatt, 2009). ER-diagrams have three basic elements including entities, attributes and relationships. Entities are the things for which, ...

Purchase this Solution

Free BrainMass Quizzes

This tests some key elements of major motivation theories.

Operations Management

This quiz tests a student's knowledge about Operations Management

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations