Question: Complete the SQL DDL definition of the bank database of Figure to include the relations loan andborrower. create table customer (customer-name char(20), customer-street char(30), customer-city
Complete the SQL DDL definition of the bank database of Figure to include the relations loan andborrower.

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)
Step by Step Solution
3.43 Rating (169 Votes )
There are 3 Steps involved in it
Create table loan loannumber char10 branchname char15 amount integer primary key loannumb... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
16-CS-DB (160).docx
120 KBs Word File
