Question: Use ERDPlus tool available at https://erdplus.com to create ER diagram Re-draw the below ER diagram for the BANK schema and use the (min, max) notation
Use ERDPlus tool available at https://erdplus.com to create ER diagram
Re-draw the below ER diagram for the BANK schema and use the (min, max) notation to specify the structural constraints as indicated in below ER diagram and as refined below in "Relationship type constriants":

Relationship type constraints are -BRANCHES: BANK (min, max) = (1, 1) and BANK BRANCH (min, max) = (1*) " ACCTS: ACCOUNT (min, max) = (1,500) and BANK-BRANCH(min, max) = (1, 1) -LOANS: LOAN (min, max) = (1,1000) and BANK BRANCH(min, max) = (1,1) " A C: ACCOUNT(min, max) (1.*) and CUSTOMER(min, max) = (1,1) LC: CUSTOMER(min, max) = (1,1) and LOAN(min, max) = (1,2) ER Diagram for BANK Schema: BANK BRANCHES BANK BRANCH CodeNmeAddr Addr Branch no LOANS Acct Balance Loan no ACCOUNT Type Type A C LC Phone CUSTOMER Addr
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
