Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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