Business requirements for database design

Assignment Help Operation Management

Reference no: EM132298134

You will draw a Physical ERD (Entity Relationship Diagram), complete with Foreign key attributes for the following case. You must state all assumptions and questions necessary. Moreover, you should make some effort to define attributes (i.e. fields as well as primary and foreign keys) for the entities. As ever, please state assumptions underlying your model as well as questions generated by it.

Worldwide events: Business Requirements for Database Design

Worldwide 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.

Reference no: EM132298134

Questions Cloud

What is the minimum production quantity : What is the minimum production quantity (n) necessary to make production cost less than purchase cost?

Which motivational level does alderfer erg theory function : Which theorist developed the theory of motivation based on internal needs? At which motivational level does Alderfer's ERG theory function?

Introduction of hilton worldwide for business strategy : Write an introduction of Hilton Worldwide for business strategy.

Numerically controlled semi-automatic lathe : What is the breakeven point for the numerically controlled semi-automatic lathe? What is the breakeven point for the machine center?

Business requirements for database design : Worldwide events: Business Requirements for Database Design

To develop effective relationship marketing : To develop effective relationship marketing, a company must first understand its targeted consumers' buying influences and behaviors.

Mentioned takeover was hostile : You and your three best friends are avid environmentalists. Explain (in detail) a few of the ways that you can defend from a hostile takeover.

Describe the difference between leadership and management : Describe the difference between leadership and management, include the difference between assigned leadership and emergent leadership.

Foreshadows approach to qualitative research : How can a central question be written so that it encodes and foreshadows an approach to qualitative research?

User Account

All Pages