Athletic events for local high school athletes

Assignment Help Operation Management

Reference no: EM131270632

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 in- cludes 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: EM131270632

Questions Cloud

Self-control is the preferred control method : Do you think that behavior is a function of its consequences? Explain. Does good listening have to involve verbally responding to the speaker? What do you think about this statement: “Self-control is the preferred control method”?

What is characteristic of virtual enterprise : Why a company should not outsourced its core element within a product? What other factors can be outsourced? What is characteristic of virtual enterprise?

What is the function of information technology department : What is the function of the information technology department at many workplaces. What is your opinion of the new law in Korea, the antigraft law. See the article in annoucements if not sure about the law.

Company revenues and thereby really impress company brass : Dewey Cheatham is the new Vice President of Marketing for a large online search engine company, Pottstown Innovative Enterprises (AKA, PIE). Dewey has been doing some research into how he can increase the Company’s revenues and thereby really impress..

Athletic events for local high school athletes : 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. SportTech asks y..

Threats that mattel faced in global competitive environment : The global toy industry is a very competitive environment and accounts for $10 billion a year in sales. Mattel, the world's largest global toy company, has earned billions of dollars from the world's bestselling doll, Barbie, which was introduced ove..

Formulate linear program to meet the demand requirements : During the next three months, General Cars must meet (on time) the following demand for trucks and cars: month 1 – 400 trucks, 800 cars; month 2 – 300 trucks, 300 cars; month 3 – 500 trucks, 500 cars. During each month, at most 1,200 vehicles can be ..

The demand requirements at minimum cost : During the next three months, General Cars must meet (on time) the following demand for trucks and cars: month 1 – 400 trucks, 800 cars; month 2 – 300 trucks, 300 cars; month 3 – 500 trucks, 500 cars. During each month, at most 1,200 vehicles can be ..

Researches your product or services target market : Select a local company and one of its products or services. Create a 1,400-word Discussion Guide for your selected product or service to be used during the course of a Focus Group that researches your product or services target market.

User Account

All Pages