CREATETABLE major (
id INTNOTNULLAUTO_INCREMENT,
code INTNOTNULL,
school VARCHAR(40)NOTNULL,
college VARCHAR(40)NOTNULL,
major VARCHAR(40)NOTNULL,
num INTNOTNULL,fullINTNOTNULLdefault1,
tongkao INTNOTNULLdefault0,PRIMARYKEY(id));CREATETABLE exam (
id INTNOTNULLAUTO_INCREMENT,firstVARCHAR(40)NOTNULL,secondVARCHAR(40)NOTNULL,
third VARCHAR(40)NOTNULL,
forth VARCHAR(40)NOTNULL,PRIMARYKEY(id));CREATETABLE major_exam (
major_id INTNOTNULL,
exam_id INTNOTNULL,FOREIGNKEY(major_id)REFERENCES major(id),FOREIGNKEY(exam_id)REFERENCES exam(id));
读者应根据需要自行修改。