为choose表添加外键约束,约束名为choose_student_fk,外键为student_no,连接到 student表的stuednt_no字段,以下命令正确的是_()
A.alter table choose add constraint choosestudent_fk FOREIGN KEY (student_no) B.alter table choose add constraint choose_student_fk FOREIGN KEY (student_no) REFERENCES student(stuednt_no) C.alter table choose add constraint choose_student_fk FOREIGN KEY (student_no) REFERENCES student; D.alter table choose add constraint choose_student_fk REFERENCES student(stuednt_no)