What entity types are directly required for a performance For each of those

What entity types are directly required for a

This preview shows page 2 - 6 out of 6 pages.

What entity types are directly required for a performance? For each of those entity types: which if any require a performance? Draw below, and point to , the EXACT elements of the ER diagram that support your answers. 2
Image of page 2
In the EER modeling process, what does inheritance mean? Give one specific example of it. If the answer to the disjointness question is “Overlap” for the supertype “Pool Table”, what does that mean? Use only the EER diagram on page 6 of the exam to answer any of the next 2 questions. Why (not how ) was the entity “Offering” broken down into subtypes? Be precise and complete in your answer. Is there a service that is neither a repair nor maintenance? Is there a service that is both a repair and a maintenance? Draw below and point to the specific parts of the ER diagram that confirm your answers. 3
Image of page 3
In database design, what is the difference between a relation and a relationship ? What is necessary for a relation to be in 1NF? Use only the ER and EER diagrams on pages 5 and 6 to answer any of the next 2 questions. Count and name the relations that would be created from the part of the ER diagram that is fully inside the solid rectangle on page 5. Draw the logical schema of relations that would result from the part of the EER diagram that is fully inside the dashed rectangle on page 6. Customers are people; enforce 1NF. 4
Image of page 4
CONCERT SEASON Season Open Date (Year, Month, Day) CONCERT Concert Number {Concert Date (Time, Year, Month, Day)} COMPOSITION Composition ID (Composer Name, Composition Name) {Movement ID (Movement Name, Movement Number)} SOLOIST Soloist ID Soloist Name CONDUCTOR Conductor ID Conductor Name PERFORMANC E Schedule s Conduct s {DateLastPerformed } SolosIn Contains (CondFName, CondLName) (SolFName, SolLName) ER Diagram: Page 5 5
Image of page 5
EER Diagram: Page 6 6 Genera tes
Image of page 6

You've reached the end of your free preview.

Want to read all 6 pages?

  • Spring '14
  • B MAK
  • Entity-relationship model, Data structure diagram

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes