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) )