Draw a physical erd complete with foreign key attributes

Assignment Help Management Information Sys

Reference no: EM131866519

Minimum 5 tables. 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: EM131866519

Questions Cloud

Please discuss openly and candidly : Please discuss openly and candidly. Also, when security and ethics violations to occur, what should be the penalties for each occurrence?

What might be some ways that culture can influence : Consider your own experiences, the communication process, and some of the differences in cultural norms.

How do these principle contribute to the successful function : How do these principles contribute to the successful function or dysfunction of this branch of government?

Which of the following statements would be most accurate : The terms goal and objective should not be used interchangeably. Goals are philosophical while objectives are performance-based.

Draw a physical erd complete with foreign key attributes : 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.

Discuss the change in organizational structure : Discuss 5 skills that are inique to the successful manager of the 21st century. Consider in your answer workplace dynamics of new organizations.

What is the mission statement for the company : Think of the organization your consultant group is working to help, what is the mission statement for the company?

Describe how the media mix has evolved : If you were a member of the team planning the next year's campaign, what other media might be useful and why?

Show the allocation of dividends to each class of stock : Show the allocation of dividends to each class of stock, assuming the preferred stock dividend is 6% and noncumulative

User Account

All Pages