A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account:
Posted: Fri Jul 08, 2022 6:16 am
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, Debit Interest Rate
LOAN: Acct No, Date Opened, Balance, Interest Rate, Payment
Using generalization, develop an EER (Enhanced Entity-Relationship) model segments to
represent the following situations:
1. Assume that each account must exactly one of these subtypes.
2.
Assume that each account must be at least one of these subtypes.
1.
Create the diagrams
Following are the attributes for each type of account:
CHECKING: Acct No, Date Opened, Balance, Service Charge
SAVINGS: Acct No, Date Opened, Balance, Debit Interest Rate
LOAN: Acct No, Date Opened, Balance, Interest Rate, Payment
Using generalization, develop an EER (Enhanced Entity-Relationship) model segments to
represent the following situations:
1. Assume that each account must exactly one of these subtypes.
2.
Assume that each account must be at least one of these subtypes.
1.
Create the diagrams