ISYS 464:Managing Enterprise DataPractice Chapter 3 SolutionsQuestion 1Assume the following scenario :A bank has three types of accounts: checking, savings, and loan. Following are the attributes for eachtype of account:CHECKING: Acct No, Date Opened, Balance, Service ChargeSAVINGS: Acct No, Date Opened, Balance, Interest RateLOAN: Acct No, Date Opened, Balance, Interest Rate, PaymentAssume that each bank account must be a member of exactly one of these subtypes. Usinggeneralization, develop an EER model segment to represent this situation.
Question 2Draw an EER diagram for the following problem:A nonprofit organization depends on a number of different types of persons for its successfuloperation. The organization is interested in the following attributes for all of these persons:SSN, Name, Address, City/State/Zip, and Telephone.