Chapter C, Problem P1AYK

To determine

To Determine: An ERD from the given information of a database for keeping track of the sponsor, event, location and the contact person.

Answer to Problem P1AYK

Solution: The Entity Relationship Diagram is commonly known as an ERD or an ER diagram. The ERD is used for illustrating various entities such as objects, concepts and people and their relation to one another within a specific system. Such diagrams are utilized to design and define relational database and is commonly used in business information systems, education and software engineering.

Explanation of Solution

Given: SportTech events puts on athletic events for local high school athletes. The company needs a database designed to keep track of the sponsor for the event and where event is located. Each event needs a description, date and cost. The company would also like to have a list of potential sponsors, 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.

An ERD displays the relationships of different entity sets of a database. An entity refers to a component of data. Hence, we can say that an ERD demonstrates the logical structure of a database. An ERD looks similar to a flowchart but its uniqueness lies in its specialized symbols and their meanings. The ER models have a defined set of symbols which are rectangle, oval or diamond-shaped. The connecting lines between these symbols display their relations and interconnection.

The given information includes the following that is to be incorporated to create the ERD.

• The attributes of the Event entity include event type, event date and the event cost.
• The attributes of the Sponsor entity include name, contact number and address.
• The attributes of the Contact Person entity include name and phone number.
• The attributes of the Location entity include location ID and the contact person.

The ERD created below contains all the given details. Each component of the database is related to one another as shown in the diagram.

Conclusion: Hence, the required ERD based on the given details has been created.