USE sample1;
CREATE TABLE customer(
[customer_id]          varchar(11)              NOT NULL ,
[customer_name]        VarChar(30)              NOT NULL ,
[customer_street]      VarChar(50)              NOT NULL ,
[customer_city]        varchar(30)              NOT NULL 
);
CREATE TABLE account (
[account_number]       varchar(5)               NOT NULL,
[balance]              dec(10,2)                NOT NULL
);
CREATE TABLE depositor (
[customer_id]          varchar(11)              NOT NULL ,
[account_number]       varchar(5)               NOT NULL
);