create_sc_tables.txt

Delphi编写的基于Oracle的分布式数据库的演示程序

drop table sc;
drop table course;
drop table student;
drop table dep;
drop table manager;

create table manager
(userid varchar2(4),
passwd  varchar2(3));

insert into manager values('thm','11');

CREATE  TABLE  dep
(dno number(3) constraint PK_Dno1 PRIMARY KEY 
CONSTRAINT
CHECK1_DNO1 CHECK(DNO BETWEEN 10 AND 50),
 dname char(10),
 tel  char(8)
);
CREATE  TABLE  student
(sno number(6) constraint PK_sno1 PRIMARY KEY,
 sname char(6),
 sex char(2) CONSTRAINT CHECK_sex1
CHECK(sex IN ('男', '女')),
 birth date  default sysdate,
 passwd  varchar2(4),
 dno number(3) constraint fK_dno1 REFERENCES DEP(DNO)
);
CREATE  TABLE  course
(cno char(8) constraint PK_cno1 PRIMARY KEY,
 cname char(10) not null,
 credit  number(1),
 ctime   number(2),
 quota   number
);

CREATE  TABLE  sc
( constraint pk_sc1 PRIMARY KEY (sno,cno),  
 sno number(6) constraint fK_sno REFERENCES student(sNO),
 cno char(8) constraint fK_cno REFERENCES course(cno),
 grade number(3)
 );

insert into dep 
values('10','中文系','62785656');
insert into dep 
values('20','外语','62783451');
insert into dep 
values('30','计算机系','62785523');
insert into dep 
values('40','无线电系','62785529');
insert into dep 
values('50','自动化','62785556');


INSERT INTO student
 VALUES(980001,'李宏','男','03-1月-1981','11','10');
INSERT INTO student
 VALUES(980002,'王明','男','01-1月-1982','11','10');
INSERT INTO student
 VALUES(980012,'刘华','男','05-1月-1983','11','50');
INSERT INTO student
 VALUES(980015,'朱敏','女','02-1月-1985','11','50');
INSERT INTO student
 VALUES(980016,'李维一','男','03-1月-1983','11','50');
INSERT INTO student
 VALUES(980017,'丁一','女','12-1月-1980','11','50');
insert into student (sno, sname,dno)
values (999998,'王东','50');


INSERT INTO course
values('20788923','Java语言','3',11,120);
INSERT INTO course
values('20533323','英语阅读','4',12,60);
INSERT INTO course
values('20133323','机械制图','2', 23,50);
INSERT INTO course
values(20133324,'软件技术基础',2,53,90);
INSERT INTO course
values('20133378','物理','3',45,90);


INSERT INTO sc
VALUES(980001,'20788923',87);