Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Select the EER model shown in the attachment that best represents the information in the following description. Pay attention to the definitions of the entities

Select the EER model shown in the attachment that best represents the information in the following description. Pay attention to the definitions of the entities and the relationship, as well as the superclass/subclass structure!

The database is used to keep track of the units who march in the Fourth of July parade, along with the sponsors who support them.

For each unit, the database records the unit's name and information about what the unit does as their act during the parade. Some units consist of many people. For those units, the database also records the number of people in the unit, and the name of the person who is in charge of organizing the unit. For units that consist of only 1 person, the database records the person's actual name (which is usually different from the UnitName).

Each unit may be associated with one sponsor. Information about the sponsor includes the name of the sponsoring organization and the name and phone number of the sponsor's contact person. Some sponsors are very generous, and support more than one unit. Sponsor information isn't entered into the database unless they have committed to sponsor at least 1 unit.

For example, the High School Marching Band is sponsored by the High School Music Club. The Band has 30 members, and they will march and play music. The band director is in charge of organizing the group. The Music Club provided the Band's t-shirts.

Another unit is Charlie the Clown, who makes balloon sculptures as he walks along. His real name is Alex Forbes -- he doesn't have a sponsor.

image text in transcribed

  • A. EER Diagram A.
  • B. EER Diagram B
  • C. EER Diagram C
Sponsorld Unit Name Contact Name Unit Sponsors Sponsor Parade Act Contact Phone) SponsorName) GroupUnit SoloUnit NumPeople UnitOrganizer) (PersonName Sponsorld Unit Name ContactName Unit Sponsors Sponsor ParadeAct ContactPhone SponsorName GroupUnit Solo Unit NumPeople UnitOrganizer) (PersonNam Sponsorld Unit Name ContactName Unit Unit Sponsors Sponsor Parade Act Contact Phone Sponsor Name GroupUnit SolaUnit NumPeople UnitOrganizer

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

Step: 3

blur-text-image

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

Practical Azure SQL Database For Modern Developers Building Applications In The Microsoft Cloud

Authors: Davide Mauri, Silvano Coriani, Anna Hoffma, Sanjay Mishra, Jovan Popovic

1st Edition

1484263693, 978-1484263693

More Books

Students also viewed these Databases questions