$10$:$27$

Back

Lab $1$: Database Design

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 keyc

Use Michosoft Access to create

$10$:$27$

Back Lab $1$: Database Design inrormation aescridea above. Iaentiry the primary keys and foreign keys.

Use Microsoft Access to create table for the database.

Submit Microsoft Word document with the screenshots of the tables in your database.