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