求救数据库系统设计：行 12在关键字 'FOREIGN' 附近有语法错误。 17 行: 'PERSON_ID' 附近有语法错误。

USE 员工培训管理系统
GO
CREATE TABLE COURSE(
COURSE_ID CHAr(20) ,
COURSE_NAME CHAr(20),
PERSON_ID CHAr(20),
COURSE_INTRO CHAr(20),
COURSE_BOOK CHAr(20),
COURSE_CLASSROOM CHAr(20),
COURSE_NUMBER INTEGER,
COURSE_CLASSTIME CHAr(20),
COURSE_STATE_CODE CHAr(20),
PRIMARY KEY(COURSE_ID)
FOREIGN KEY(PERSON_ID)REFERENCES PERSON(PERSON_ID),
FOREIGN KEY(COURSE_STATE_CODE)REFERENCES COURSE_STATE(COURSE_STATE_CODE));

CREATE TABLE TRAINING_PLAN(
TRAINING_PLAN_ID CHAr(20)
PERSON_ID CHAr(20),
TRAINING_PLAN_COURSE CHAr(20),
TRAINING_PLAN_SCORE CHAr(20),
APPRAISEMENT_CODE CHAr(20),
TRAINING_PLAN_EXAM_DATE CHAr(20),
PRIMARY KEY(TRAINING_PLAN_ID),
FOREIGN KEY(PERSON_ID)REFERENCES PERSON(PERSON_ID),
FOREIGN KEY(APPRAISEMENT_CODE)REFERENCES APPRAISEMENT(APPRAISEMENT_CODE));

CREATE TABLE COURSE_STATE(
COURSE_TATE_CODE CHAr(20),
COURSE_STATE_DESCRIPTION CHAr(20),
PRIMARY KEY(COURSE_TATE_CODE));
INSERT INTO COURSE_STATE VALUES('0','选课中')
INSERT INTO COURSE_STATE VALUES('1','进行中')
INSERT INTO COURSE_STATE VALUES('2','已结束')

CREATE TABLE APPRAISEMENT(
APPRAISEMENT_CODE CHAr(20),
APPRAISEMENT_DESCRIPTION CHAr(20),
PRIMARY KEY(APPRAISEMENT_CODE));
INSERT INTO APPRAISEMENT VALUES('0','未考核')
INSERT INTO APPRAISEMENT VALUES('1','不及格')
INSERT INTO APPRAISEMENT VALUES('2','及格')
INSERT INTO APPRAISEMENT VALUES('3','良好')
INSERT INTO APPRAISEMENT VALUES('4','优秀')

CREATE TABLE PERSON(
PERSON_ID CHAr(20),
PERSON_PASSWD CHAr(20),
PERSON_AUTHORITY CHAr(20),
PERSON_NAME CHAr(20),
PERSON_SEX CHAr(20),
PERSON_BIRTHDAY CHAr(20),
PERSON_DEPARTMENT CHAr(20),
PERSON_JOB CHAr(20),
PERSON_EDU_LEVEL CHAr(20),
PERSON_SPECIALITY CHAr(20),
PERSON_ADDRESS CHAr(20),
PERSON_TEL CHAr(20),
PERSON_EMAIL CHAr(20),
PERSON_STATE CHAr(20),
DEPARTMENT_ID CHAr(20),
PRIMARY KEY(PERSON_ID,PERSON_NAME),
FOREIGN KEY(DEPARTMENT_ID)REFERENCES DEPARTMENT(DEPARTMENT_ID));

CREATE TABLE DEPARTMENT(
DEPARTMENT_ID CHAr(20),
DEPARTMENT_NAME CHAr(20),
DEPARTMENT_MANAGER CHAr(20),
DEPARTMENT_INTRO CHAr(20),
PRIMARY KEY(DEPARTMENT_ID));

PRIMARY KEY(COURSE_ID) 的后面少了一个逗号

不知道

你好！ PRIMARY KEY(COURSE_ID) FOREIGN KEY(PERSON_ID)REFERENCES PERSON(PERSON_ID), PRIMARY这一行没逗号 TRAINING_PLAN_ID CHAr(20) PERSON_ID CHAr(20), TRAINING_PLAN_ID CHAr(20)这一行还是没逗号 如果对你有帮助，望采纳。