![](https://lstatic.shangxueba.com/sxbzda/h5/images/m_q_title.png)
在学生成绩表Score中将studentNo, courseNo, termNo定义为主码,正确的是:()。
A、CREATE TABLE Score (studentNo char(7) NOT NULL, courseNo char(3) NOT NULL, termNo char(3) NOT NULL, score numeric(5, 1) DEFAULT 0 NOT NULL, PRIMARY KEY (studentNo, courseNo, termNo) )
B、CREATE TABLE Score (studentNo char(7) NOT NULL PRIMARY KEY, courseNo char(3) NOT NULL PRIMARY KEY, termNo char(3) NOT NULL PRIMARY KEY, score numeric(5, 1) DEFAULT 0 NOT NULL, )
C、CREATE TABLE Score (studentNo char(7) NOT NULL CONSTRAINT ScorePK1 PRIMARY KEY, courseNo char(3) NOT NULL CONSTRAINT ScorePK2 PRIMARY KEY, , termNo char(3) NOT NULL CONSTRAINT ScorePK3 PRIMARY KEY, , score numeric(5, 1) DEFAULT 0 NOT NULL, )
D、CREATE TABLE Score (studentNo char(7) NOT NULL, courseNo char(3) NOT NULL, termNo char(3) NOT NULL, score numeric(5, 1) DEFAULT 0 NOT NULL, PRIMARY KEY ScorePK (studentNo, courseNo, termNo) )
![](https://lstatic.shangxueba.com/sxbzda/h5/images/tips_org.png)