课程表.sql

sql教务管理系统数据库的建立

create table Course
(
Cono             char(10),
Coname           char(20),
Cotime           datetime,
Comanypeople     char(10),
Tno              char(20),
Cofrade          char(10),
primary key(Cono),
foreign key(Tno)references Teacher(Tno)
)
-- alter table Course add Cograde char(10)