Question
4. (10 points) A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each types of account: a. CHECKING:
4. (10 points) A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each types of account: a. CHECKING: Account No., Date Opened, Balance, Service Charge b. SAVINGS: Account No., Date Opened, Balance, Interest Rate c. LOAN: Account No., Date Opened, Balance, Interest Rate, Term, Payment Assume that each bank account must be exactly one of these three types. Using generalization, develop an EER model to represent this situation. You need to specify both completeness and disjointness constraints and include a subtype discriminator.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started