Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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.

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.

Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts
Section: Chapter Questions
Problem 1.14CP
See similar textbooks
icon
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.

Sport Tech Events Tutorial 5 File Edit Select View Insert Arrange Insert 10₂ Shapes ▾ Entity Relationship Import Export Salesforce Import ▾ My Saved Shapes Drop shapes to save + Shapes X Import Data X Arrange Share Help What's New Saved Liberation Sans 7 pt + B IU A = T Conceptual Entity Relationship Diagram Events Event ID Event Description Event Date PK Event_ID Events DO Hosted By Hosts Int(6) Event Description Char(40) Event Date Date Int(10) Event Cost Int(6) Int(6) FK Sponsor_ID FK Location ID Sponsors Location ID Contact Person Location Phone >O Location Physical Entity Relationship Diagram Location Int(6) Contact Person char(40) Location Phone Char(10) HPK Location_ID + Feature Find A Sponsor Sponsor ID Sponsor Name Sponsor Phone Sponsor Int(6) Sponsor Name Char(40) Sponsor_Phone Char(10) Sponsor_Address Char(50) PK Sponsor_ID ► Present 1px Share ... MORE
Transcribed Image Text:Sport Tech Events Tutorial 5 File Edit Select View Insert Arrange Insert 10₂ Shapes ▾ Entity Relationship Import Export Salesforce Import ▾ My Saved Shapes Drop shapes to save + Shapes X Import Data X Arrange Share Help What's New Saved Liberation Sans 7 pt + B IU A = T Conceptual Entity Relationship Diagram Events Event ID Event Description Event Date PK Event_ID Events DO Hosted By Hosts Int(6) Event Description Char(40) Event Date Date Int(10) Event Cost Int(6) Int(6) FK Sponsor_ID FK Location ID Sponsors Location ID Contact Person Location Phone >O Location Physical Entity Relationship Diagram Location Int(6) Contact Person char(40) Location Phone Char(10) HPK Location_ID + Feature Find A Sponsor Sponsor ID Sponsor Name Sponsor Phone Sponsor Int(6) Sponsor Name Char(40) Sponsor_Phone Char(10) Sponsor_Address Char(50) PK Sponsor_ID ► Present 1px Share ... MORE
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Table
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
CMPTR
CMPTR
Computer Science
ISBN:
9781337681872
Author:
PINARD
Publisher:
Cengage
SEE MORE TEXTBOOKS