Perform the following tasks:

• Start with your entity-relationship (EER) model and now map your model to a logical database design. Ensure that your logical database is normalized per the forms 1NF, 2NF, 3NF, and BCNF.

 

 

Transcribed Image Text:

Name Code Address Bank N (Loan_id) (Loan_type) Amount ER Diagram of a Bank Has Offer N Loan Custid M (Branch id) Availed by Branch N Customer N Maintain Name M Address) Account Name Phone Hold by Address Account No Acc_Type (Balance Name Code Address Bank N (Loan_id) (Loan_type) Amount ER Diagram of a Bank Has Offer N Loan Custid M (Branch id) Availed by Branch N Customer N Maintain Name M Address) Account Name Phone Hold by Address Account No Acc_Type (Balance

Answer rating: 100% (QA)

The EntityRelationship ER diagram you provided represents the structure of a banks database To map this model to a logical database design with normal... View the full answer