SportTech Events.SportTech Events 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 the event is located. Each event needs a description, date, 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, a contact person, and a phone number. A particular event will use only one location, but a location may be used for multiple events. SportTech asks you to create a Conceptual Entity Relationship Diagram from the information described above. Sport Tech Events Tutorial 5File Edit Select View Insert ArrangeInsert10₂Shapes▾ Entity RelationshipImportExportSalesforce Import▾ My Saved ShapesDrop shapes to save+ ShapesXImport DataXArrange Share Help What's New SavedLiberation Sans7 pt + B IU A = TConceptual EntityRelationship DiagramEventsEvent IDEvent DescriptionEvent DatePK Event_IDEventsDOHosted By HostsInt(6)Event Description Char(40)Event DateDateInt(10)Event CostInt(6)Int(6)FK Sponsor_IDFK Location IDSponsorsLocation IDContact PersonLocation Phone>OLocationPhysical EntityRelationship DiagramLocationInt(6)Contact Person char(40)Location Phone Char(10)HPK Location_ID+Feature FindASponsorSponsor IDSponsor NameSponsor PhoneSponsorInt(6)Sponsor Name Char(40)Sponsor_Phone Char(10)Sponsor_Address Char(50)PK Sponsor_ID► Present1pxShare...MORE

Here is a Conceptual Entity Relationship Diagram (ERD) for the SportTech Events database:

Answered: SportTech Events. SportTech Events…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

SportTech Events.

SportTech Events 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 the event is located. Each event needs a description, date, 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, a contact person, and a phone number. A particular event will use only one location, but a location may be used for multiple events. SportTech asks you to create a Conceptual Entity Relationship Diagram from the information described above.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions