Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw an ER/EER diagram. Universe of Discourse Recently the Rock city has become one of the most popular cities in northern hemisphere for hosting the

Draw an ER/EER diagram. Universe of Discourse Recently the Rock city has become one of the most popular cities in northern hemisphere for hosting the large shows and events. The Rock city Mayor has launched an initiative for bringing together the organizers, sponsors and hosts of these shows in order to provide an efficient management for the process. It is intended to provide an online system where multiple organizers or stakeholders may register and exchange information and/or develop relationships. In order to register, organizers must provide their organization name, address, telephone(s), fax, email and web address, name of a contact person, and his/her telephone. One organizer may organize multiple shows. Each show is described by a unique name, its start and end dates, target audience (in terms of age group), preferred area (Rock city suburbs), and number of expected attendees. Essentially there are three different kinds of shows Trade, Sports, and Entertainment. For sporting shows it is also required to keep data on whether it is a local, state, national or international show, and the list of main competitions being held (e.g. swimming, tennis, etc.). Entertainment shows are generally classified into family, dance & theatre and food & wine. Every entertainment show also carries a rating. Trade shows are further described through the list of participating missions, which may include mission name and its country, as well as the trade area (e.g. Apparel, Pharmaceutical etc.) Various venues hosts such as hotels chains, conference centres owners etc, can also register with their name, address, telephone(s), fax, email and web address, name of a contact person, and his/her telephone. Hosts also need to provide the information on their venues. One host may own several venues. Each venue is described by its name, address, managers name, telephone number, fax and email. Within each venue, there can be several locations where show events may be organized. The hosts also need to provide full description of the potential locations within each venue. Each location is described by a name for example Longshow Hall Room12, etc, which is unique at least within the venue. For each location, the seating capacity is also required. There are essentially two types of locations, Indoor and Outdoor. For indoor locations, it is also required to keep information on the facilities available which consists of two Boolean attributes: Data Assignment ion available (Y/N), Internet available (Y/N). For outdoor locations it is necessary to record the dimensions in meters, and the name of the closest available parking. A show may be hosted at one or more venues. Many of the larger venues can also host more than one show at a time. A show generally comprises of several events. Each event is described by a name e.g. Research and Innovation can be an event in a trade show, or Fruit Circus may be an event in an entertainment show. The event names are often non-unique across shows. They are also non-unique within a given show since the same event may be held on different dates/times. In fact the same event may even be held at the same date/time but in two or more different locations. Thus the location as well as date/time for each event must be recorded. Most shows also have one or more sponsors. The system must have the ability to record general data about sponsors such as their name, address, telephone(s), fax, email and web address, name of a contact person, and his/her telephone. Some of the more prominent sponsoring bodies support several shows. It is important to record the value of sponsorship for each sponsor against each show that it supports. This value is divided into two amounts: Cash and In-kind. For in-kind support, a long textual space is required so that a full description of the nature of support may be recorded.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation And Management

Authors: Peter Robb,Carlos Coronel

5th Edition

061906269X, 9780619062699

More Books

Students also viewed these Databases questions