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":

Use ERDPlus tool available at https://erdplus.com to create ER diagram Re-draw the

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!