Question: o Design a Relational Data Model for the following ER model of a bank BrancbNo Addr BankIDName Addr Bank ranch of Branch 1 BankAcc BankLoan


o Design a Relational Data Model for the following ER model of a bank BrancbNo Addr BankIDName Addr Bank ranch of Branch 1 BankAcc BankLoan an pe Account Loan alan ount CustLoan CustAcc Customer ame Phone Addr Comments on the ER-diagram The Bank entity represent the banks The Branch entity represent the branches of a bank Important note: The attribute BranchNo in the Branch is the attribute that is required to form a key for a Branch entitv (Le.: BranchNo is like the name attribute in Dependent in the Company Database example) The Account entity represent the bank accounts The Loan entity represent the bank loans The Customer entity represent the bank customers The key in each (non-weak) entity is underlined with a solid line The Branch_Of relation represents the branches of each bank The BankAcc relation represents the "which-branch-manages-which-bank-account" relationship The BankLoan relation represents the "which-branch-makes-which-loan" relationship The CustAcc relation represents the "which-customer-has-which-bank-account" relationship The CustLoan relation represents the "which-customer-has-which-loan-account" relationship
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
