CIS 484 - Assignment 02.docx - CIS 484 Assignment 02(20...

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

CIS 484 Assignment 02 (20 points) Due Date: 09 /19/2018, 11:59 CT Develop an Enhanced Entity Relationship (EER) Diagram for each of the following questions: (14 Points). Q1. For a library, the entity type HOLDING has four subtypes: BOOK, AUDIO BOOK, DVD, and SOFTWARE. Draw a separate EER diagram segment for each of the following situations: a) At a given time, a holding must be exactly one of these subtypes. b) A holding may or may not be one of these subtypes. However, a holding that is one of these subtypes cannot at the same time be one of the other subtypes.
(6 Points). Q2. A bank has three types of accounts: checking, savings, and loan. Following are the attributes

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture