A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account:
CHECKING: Acct No, Date Opened, Balance, Service Charge
SAVINGS: Acct No, Date Opened, Balance, Interest Rate
LOAN: Acct No, Date Opened, Balance, Interest Rate, Payment
Assume that each bank account must be a member of exactly one of these subtypes. Using generalization, develop an EER model segment to represent this situation using the traditional EER notation, the Visio notation, or other tools like Lucidchart / Draw.io. Remember to include a subtype discriminator.

Respuesta :

Answer:

please find the attachment of a graph:

Explanation:

Description of the model:

  • Generalization is the method used here just for the EER model, which sweeping generalization is a way to identify the common characteristics of a sequence to create a common entity.
  • This is an approach from the bottom up. Its verification, savings, and credit firms are extended to a higher-level object's account.
  • So, the entity entities (Account) are the common traits of these bodies. As well as the specific qualities are the part of specialized entities (checks, savings, and loans).
  • This EER model is shown via the subgroup and supertype notes.
  • The Balance has calculated the distance, throughout the entity type entity are key patterns of the subgroup entities.
  • The wood beaded includes Acct No, Balanced and Open Date.
  • The key was its underliner Acct No. the very first key. CHECKING, SAVINGS, and LOAN are the subsection organizations of the Supertype Account.
  • Its subtypes get the traits that are not normal.
  • It Testing feature is the uncommon extra fee feature.
  • Its SAVINGS post-type feature has the peculiar exchange rate feature.
  • Its LOAN subgroup feature produces unusual interest in fixed payment characteristics.
Ver imagen codiepienagoya

Enhanced Entity relationships[EER] represent the requirements and complexities of a complex database.

What is Enhanced Entity-relationship?

Here, the account entity generalized into three entities and these are checking, savings, and loan.

Also, the common attribute the three of them have can be considered in the account entity which is common in them while the individual attributes must be specified under its own entity.

EER models are the helpful tools used for designing databases that have high-level models.

Learn more about databases on:

https://brainly.com/question/518894

Ver imagen topeadeniran2
ACCESS MORE