In level 1 diagram logical error 1 is data store ds1

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

3
WBIT 3110, Unit 3 HW BFROM TEXTBOOK APPENDIX 7A4.Corresponding to Problem and Exercise 1, on page 234. Draw a use-case diagram for the situation described in Problem and Exercise 9, page 214, at the end of the main body of Chapter 7. You may use the drawing tool in Word, or, if you have access to MS Visio, you may use that and either upload a separate Visio document, or copy that diagram from Visio into this document. This question is worth 15% of the assignment.4
WBIT 3110, Unit 3 HW BFROM TEXTBOOK CHAPTER 85.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 CustomerPatron: Patron ID, Contact, Preference.Concert: Concert ID, Concert Desc, Concert date, Ticket number, Seat Number.Seat: Seat number, Position, Price, Date, Ticket numberExplanation:5
WBIT 3110, 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?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture