Reference no: EM131867691
Must have 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.
|
What the workers do to get the nlrb to hold a de-certifation
: They contact a representative of the Service Employees International Union to discuss ousting the Teamsters as their bargaining representative.
|
|
The most economical location to produce the item is
: Shipping cost from China to Denver is $1.20 per unit, while the shipping cost from Billings, Montana to Denver is $0.20 per unit.
|
|
How much is due to walmarts inherent competitive strategy
: How much of Walmart's success is due to NAFTA and how much is due to Walmart's inherent competitive strategy?
|
|
What does that imply our roll and duties would be
: A multi-day celebration will be taking place featuring congressional VIPs, war veterans, and ethnic groups from across the state.
|
|
Complete with foreign key attributes for the given case
: 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.
|
|
Maximize profit and determine the solution
: Formulate a relevant linear programming (not integer) model or this problem to maximize profit and determine the solution.
|
|
How much would my annuity payment be
: How much would my annuity payment be if I wanted to save $2,000,000 over the next 25 years at 8%?
|
|
What are five techniques in brief
: There is a myth that these five techniques of schedule compression can fix the project schedule, but there are downsides of using each one of them.
|
|
Will b have to accept and pay for the tires in assortment
: A promptly shipped 200 pairs of tires, determining on his own the several sizes and number of pairs of each. B refused to pay, and A brought suit.
|