Convert the ER diagram to tables schemas. Figure 3.22 An ER diagram for a BANK database schema.

Convert the ER diagram to tables schemas.

 

Transcribed Image Text:

Figure 3.22 An ER diagram for a BANK database schema. Code BANK Name Addr Phone 1 BRANCHES Acct_no Ssn ACCTS N 1 ACCOUNT M A_C N Balance N Name CUSTOMER Type BANK_BRANCH Addr Addr LOANS Loan_no N LOAN N M L_C Branch_no Amount Type Figure 3.22 An ER diagram for a BANK database schema. Code BANK Name Addr Phone 1 BRANCHES Acct_no Ssn ACCTS N 1 ACCOUNT M A_C N Balance N Name CUSTOMER Type BANK_BRANCH Addr Addr LOANS Loan_no N LOAN N M L_C Branch_no Amount Type

Answer rating: 100% (QA)

To convert an EntityRelationship ER diagram into table schemas you need to create a table for each entity and relationship Looking at this ER diagram ... View the full answer