Complete the SQL DDL definition of the bank database of Figure to include the relations loan andborrower.

Transcribed Image Text:

create table customer (customer-name char(20), customer-street char(30), customer-city primary key (customer-name)) char(30), create table branch (branch-name branch-city assets primary key (branch-name), check (assets >= 0)) char(15), char(30), integer, create table account (ассоиnt-питber char(10), branch-name char(15), integer, balance primary key (account-number), foreign key (branch-name) references branch, check (balance >= 0)) create table depositor (customer-name char(20), ассоиn-нитber char(10), primary key (customer-name, account-number), foreign key (customer-name) references customer, foreign key (account-number) references account)