Corresponding to problem and exercise 13 on page 288

This preview shows page 5 - 7 out of 7 pages.

5.Corresponding to Problem and Exercise 13 on page 288.A concert ticket reservation is an association among a patron, a concert, and a seat. Select a few pertinent attributes for each ofthese entity types and represent a reservation in an E-R Diagram. This question is worth 20% of the assignment. Each entity, and it’s corresponding relation or relations, are worth 4%. Or, if you can’t do either of the above, then you can write a short written explanation, for example),if you were relating customers to orders (note that this is just an example – there are no customers or orders in the answer to this problem): One Customer Has Optional Zero or Many OrdersOne Order Has Mandatory One CustomerPatronReservationConcert Show5
WBIT 3110, Fall 2015, Unit 3 HW B6.Corresponding to Problem and Exercise 9 on page 288.Consider the E-R diagram inFigure 8-24, on page 289 of the text. For the E-R diagram provided in Figure 8-24, rather than draw in the cardinalities, list each relationshipand describe its cardinalities.Describe any assumptions you must make about relevant business rules. Are there any changes or additions you would make to this diagram to make it better? Why or why not?
12 %age POINT BONUS QUESTIONCorresponding to Problem and Exercise 15 on page 288.Consider the E-R diagram in Figure 8-25 on page 289. Are all three relationships: Holds, Goes On, and Transportsnecessary (i.e., can one of these be deduced from the other two)? Are there reasonable assumptions that make all three relationships necessary? If so, what are these assumptions? You will need to use the cardinality of the relationships to answer this question, i.e., in your answer. 6
WBIT 3110, Fall 2015, Unit 3 HW B7

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture