Business requirements for database design worldwide events

Assignment Help Database Management System

Reference no: EM131869587

Question: 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: EM131869587

Questions Cloud

What is the firm multifactor productivity : The Dulac Box plant produces wooden packing boxes to be used in the local sea food industry. Current operations allow the company to make 500 boxes per day.

Can brock use the business judgment rule as a defense : Suppose that Firm Body brought a lawsuit against Brock claiming that he had breached the duty of loyalty by not disclosing his interest in Sunglow.

Draft one sentence that explains the different viewpoint : Find a source that counters your statement (has a different viewpoint). Draft one sentence that explains the different viewpoint.

Draw a network diagram : Draw a network diagram representing the following information: the project starts with three activities, A, B, and C, which can be done concurrently.

Business requirements for database design worldwide events : Business Requirements for Database Design Worldwide Events puts on athletic events for local high school athletes. The company needs a database designed.

Discuss the concept of image : Discuss the concept of "image." How does image affect one's interpretation of an organization? How does it affect how one approaches organizational issues?

Explain the employment issue presented in scenario : Create a report in which you examine the employment issue presented in scenario. Analyze ethical considerations behind maintaining a rigid company dress policy.

Prepare revised income statements for each product : Prepare revised income statements for each product, assuming a 20 percent increase in the budgeted sales volume

How many customers on average are in the drive : A drive-through at a Fast Food serves 300 customers over a 10-hour day. On average, a customer spends 2 minutes waiting in line, 3 minutes placing the order.

User Account

All Pages