- 博客(0)
- 资源 (2)
空空如也
银行存储系统
ALTER TABLE drawslip
添加主键约束
ADD CONSTRAINT XPKdrawslip PRIMARY KEY (dw_num,acnum);
ALTER TABLE drawslip
在drawslip表中的acnum字段中添加外键约束
ADD (CONSTRAINT R_6 FOREIGN KEY (acnum) REFERENCES luser(acnum));
五、插入(insert)数据
1、插入储户表(luser)数据
insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE)
values ('00001', 3422101, '刘忠田', '男',1.72 ,'北京市朝阳区', 345);
insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE)
values ('00002', 3422102, '周正义', '男',1.78, '天津市宝坻区', 123);
insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE)
values ('00003', 3422103, '陈光标', '男',1.80, '南京市新街口', 333);
insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE)
values ('00004', 3422104, '张茵', '女',1.65, '上海市黄浦区', 234);
insert into luser (ACNUM, ID, NAME, SEX,HEIGHT, ADDRESS, BALANCE)
values ('00005', 3422105, '陈丽华', '女',1.70, '香港市旺角区', 111);
2、插入存款单表(depositslip)数据
insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)
values (98001,'00001', 120,to_date('08-08-2009','dd-mm-yyyy'), '整存整取');
insert into depositslip (DPS_NUM, ACNUM, MONEY, DPS_TIME, DPS_WAY)
values (98002,'00001', 300,to_date('10-08-2009','dd-mm-yyyy'), '整存整取');
2013-01-07
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人