Athletic events for local high school athletes

Assignment Help Operation Management

Reference no: EM132140194

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 an ERD from the information described above, and then create a normalization structure in 3NF.

Reference no: EM132140194

Questions Cloud

Keep track of all the courses offered by department : chairperson of information technology department at University of Denver, needs to create a database to keep track of all the courses offered by department.

Discuss about the inventory of hardware and software : Discussion of action to take when an emergency occurs (i.e., cold site, warm site, and hot site (SLAs) and contracts .

Ethical decisions apparent to followers and community-member : Describe several approaches leaders can take to make ethical decisions apparent to followers and community-members.

How is philosophy related to leadership : How is philosophy related to leadership? How are the philosophical themes of relationalism, ethics and reflexivity related to leadership?

Athletic events for local high school athletes : SportTech Events puts on athletic events for local high school athletes.

Difference between a team and a group of people : What is the difference between a team and a group of people?

Describe the measures of central tendency : Name and describe the measures of central tendency. Describe the role and job requirements of fieldworkers.

Process of managing the implementation of a major upgrade : What is the process of managing the implementation of a major upgrade to an acute care hospital's electronic health record system?

What are your thoughts on the global impact : Servant leader’s behaviors focus directly on recognizing followers’ contributions and helping them realize their true potential.

User Account

All Pages