bank.sql

卡内基梅隆大学软件工程课件,很全面

drop table checking;

create table checking  
(id varchar(3) constraint pk_checking primary key,  
balance decimal(10,2));

insert into checking  
values ('123', 100.00);

drop table saving;

create table saving  
(id varchar(3) constraint pk_saving primary key,  
balance decimal(10,2));

insert into saving  
values ('123', 500.00);

exit;