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.
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, ...
The solution discuses the entity relationship diagram in management analysis.