Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(EER) Extended - Entity - Relationship 1) (30 points) Consider the BANK ER diagram in Figure 1 and suppose that it is necessary to keep
(EER) Extended - Entity - Relationship
1) (30 points) Consider the BANK ER diagram in Figure 1 and suppose that it is necessary to keep track of different types of ACCOUNTS (SAVINGS ACCTS, CHECKING_ACCTS, ...), LOANS (CAR LOANS, HOME LOANS, BUSINESS LOANS, ...), and CUSTERMERS (STUDENTS, HOME OWNERS, EMPLOYEES, BUSINESSMEN, ...). Suppose that it is also desirable to keep track of each ACCOUNT's TRANSACTIONS (deposits, withdrawals, checks ...) and each LOAN's PAYMENTS; both of these include the amount, date, and time. Modify the BANK ER Diagram to form an EER diagram, using EER concepts of specialization and generalization. State any assumptions you make about the additional requirements Figure 1: An ER diagram for a BANK database schema BANK BRANCHES BANK BRANCH CodeNa Addr Branch.no Addr ACCTS LOANS Acct no Balance Loan no Amount ACCOUNT Type LOAN Type AC LC Ssn Name Phone CUSTOMER AddrStep 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