班级表.sql

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

create table Class
(
Cno              char(10),
Chowmanystudent  char(10),
Cmaxresult       char(10),
Cminresult       char(10),
Cavergeresult    char(10),
Tno              char(10),
primary key(Cno),
foreign key(Tno)references Teacher(Tno)
)