Question

ud bundle at the start of the class on the due date. ment. 1. (10 pts) Use the ER-to-relational mapping algorithm to map the BANK ER diagram to a relational schema diagram. Prepare the diagram using ERDPlus and make sure to specify all primary keys and foreign keys. (Position the relations so that the arcs from the foreign keys to the primary keys do not overlap and the referential constraints are clearly visible.) identit Weak ent. Velost. Steps 1. Regular entity ✓ regularent. 2. weak entity BANK 3. binary 1:1 relationship Code Name Addr binary: N relat. binary M:N relati IN BRANCHESN none ✓ BANK BRANCH partial key ACCTS) (LOANS) IN regular account - The LON Tree erit In regular ent. NEM AC LCN:M Phone Son Name _CUSTOMER 7 yequlay Adet Jent.

This is how i mapped the relational schema diagram. would this be correct? i feel like i am missing something.

Answer 1

Solution

Only two attribute is missing.

To map 1:N realtion in Account and Loan table.

PK of owner entity of BankBranch is also required.

Bank BANY BRAUCH Bane-Cade Cade Name Branchno Addr Addr Acount Acnt-no LOA Loan no Amount TYRe Ban ode Balance TYRE Bany codo Bankranch Branchno N A-C PECnt no L- C Lean-no SSN SSN CUstamer Phme Name Adar Telation frm nly mapping missing entity 4LOAN Actount dapendant enti ty to a relateol Both are pf bwna3 entty s aso Th this Caoe same is Rest equired