create table Course
(cno varchar(3),--課號
cname varchar(20) not null,--課名
cpno varchar(3),--先行課
ccredit real ,--學分
primary key(cno)--設置主鍵
)
insert into Course(Cno,Cname,Cpno,Ccredit)
values(1,'數據庫',5,4)  
insert into Course(Cno,Cname,Ccredit)
values(2,'數學',2)  
insert into Course(Cno,Cname,Cpno,Ccredit)
values(3,'信息系統',1,4)  
insert into Course(Cno,Cname,Cpno,Ccredit)
values(4,'操作系統',6,3)  
insert into Course(Cno,Cname,Cpno,Ccredit)
values(5,'數據結構',7,4)  
insert into Course(Cno,Cname,Ccredit)
values(6,'數據處理',2)  
insert into Course(Cno,Cname,Cpno,Ccredit)
values(7,'PASCAL語言',6,4)