Question: 3 ) At the present time, when an individual or company calls to make a reservation at either the Superdome or the New Orleans Arena,

3) At the present time, when an individual or company calls to make a reservation at either the Superdome or the New Orleans Arena, the entire process is handled manually and by one office (located offsite). With the recent population growth experienced by the city of New Orleans, it has become nearly impossible for the current scheduling office to handle all of the paperwork. Thus, they are considering the option of a database solution that handles the booking and events planning for both of these venues. The scheduling office is in charge of tracking information about customers, venues, inventory, and caterers. Please consider the following assumptions A customer can reserve a single venue or multiple venues for events. A venue can be reserved by many customers. On occasion, there may be a venue that has not yet been reserved. A caterer may provide services to many venues, but many not provide services to any. A venue will use one and only one caterer. A customer may rent various items in inventory (for their event) or may not rent any. Items in inventory may be rented by zero or many customers. . Show entity names, relationships between the entities and cardinality. Please make sure that you eliminate any many-to-many relationships that may exist.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!