.PROBLEMS (50 pts- 10 x 5pts each element, ET and RT) Consider the ER diagram for a BANK database, shown below. Each bank can have multiple branches and each branch can have multiple accounts 1. BANK BANK-BRANCH Name) Ads ACCTS ACCOUNT Type A-C L-C PhoreCUSTOMERCAd and loans. Map the BANK ER schema (Phase 2) into a relational database schema (Phase 3). Specify all primary keys and foreign keys (also referential integrity constraints). 2. (41 pts 2 (8A-8B) 16 (4 x 4 pts each element/class) 32 pts+3 x 3 pts for S, SP, C) Consider the EER diagram for a CAR DEALER database, shown below. Each VEHICLE must be either CAR, TRUCK, or SUV. CAR Engine_size Vin) (Price VEHICLE - ( d TRUCK Tonnage Model N Date SUV (No-seats SALE Address City SALESPERSON CUSTOMER Street Sid Name) Ssn Name State Map the CAR DEALER EER schema into a relational database schema (i.e., set of relational schemas). Specify all primary keys and foreign keys (also called referential integrity constraints). consider the following 2 options for Step ra 8 mapping: 8A and 8B only'. Show the relational schema design under each of the 2 options. For the rest (SALESPERSON, CUSTOMER, SALE), SHOW IT ONLY ONCE-with the 8A mapping (since in the 8B mapping it will be the same)