Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Murach's SQL Server 2012 For Developers

Authors: Bryan Syverson, Joel Murach, Mike Murach

1st Edition

1890774693, 9781890774691

More Books

Students also viewed these Databases questions

Question

5. How do instructional objectives help learning to occur?

Answered: 1 week ago

Question

4. Help trainees set challenging mastery or learning goals.

Answered: 1 week ago