Instructions

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$,$ contact person, and phone number. A particular event will use only one location, but a location may be used for multiple events. SportTech asks you to create the tables for a database from the information described above. Identify the primary keys and foreign keys.