Q:

 A bank has 3 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 traditional EER notation, the Visio notation, or the subtypes inside supertypes notation.  Include subtype discriminator.

 

Attachments:
   
   
   
   

Want to take a stab at the bounty and post a tutorial? Need clarification? Join us now or log in! Read more on how this works.