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