Entities and relationships with attributes

1. (10 marks) Given the ER diagram of the BANK database of Figure 3.22, answer the following questions with this diagram. Figure 3.22 An ER diagram for a BANK database schema. N N BANK_BRANCH BANK BRANCHES >> BANK_BRANCH Code Name Addr (Addr Branch_no ACCTS LOANS (Acct_no Amount Balance ACCOUNT (Loan_no Type LOAN Type L_C Ssn Name Phone CUSTOMER H Addr Write the relational database schema for BANK including all the entities with attributes, relationships with attributes and at least two referential integrity constraints that apply to this database. COMPANY SCHEMA for the Database Component COMPANY Database Component Entities (4 marks) Relationships (4 marks) Two referential Integrity Constraints (2 marks)