网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
在关系SC(student_id，student_name，course_id, grade)中，有student_id，course_id→ gradesmdent_id→student_name关系SC最高达到( )范式。
A．不满足
B．1NF
C．2NF
D．3NF
参考答案
更多 “ 在关系SC(student_id，student_name，course_id, grade)中，有student_id，course_id→ gradesmdent_id→student_name关系SC最高达到( )范式。A．不满足B．1NFC．2NFD．3NF ” 相关考题
考题
You need to design a student registration database that contains several tables storing academic information.The STUDENTS table stores information about a student. The STUDENT_GRADES table storesinformation about the student‘s grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key.You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table thatpoints to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?（）A. CREATE TABLE student_grades (student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY student (student_id));B. CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));C. CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES student (student_id));D. CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));
考题
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?()
A. ALTER TABLE students ADD PRIMARY KEY _ id;B. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);C. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;D. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);E. ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
考题
Which statement explicitly names a constraint? ()
A. ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students (student_id);B. ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);C. ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);D. ALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);E. ALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
考题
在关系SC(student_id,student_name,course_id,grade)中，有 student_id,course_id→grade student_id→student_name 关系SC最高达到______范式。A．不满足B．1NFC．2NFD．3NF
考题
在“学生-选课-课程”数据库中的3个关系如下：S（SNO, SNAME, SEX, AGE）；SC（SNO, CNO, GRADE）； C（CNO, CNAME, TEACHER），查找选修“数据库技术”这门课程学生的学生名和成绩，若用关系代数表达式来表示为（）。A.ПCNAME, GRADE (σCNAME=’数据库技术’(C) ⋈ПSNO, CNO, GRADE (SC) ⋈ПSNO, SNAME (S) )###SXB###B.ПCNAME, GRADE (σCNAME=’数据库技术’(C) ⋈ SC ⋈S)###SXB###C.ПCNAME, GRADE (C ⋈ SC ⋈ SC)###SXB###D.ПCNAME, GRADE (σCNAME=’数据库技术’ (ПCNAME (C)) ⋈ПSNO, CNO, GRADE (SC) ⋈ПSNO, SNAME (S) )
考题
在“学生-选课-课程”数据库中的3个关系如下：S（SNO, SNAME, SEX, AGE）； C（CNO, CNAME, TEACHER）；SC（SNO, CNO, GRADE），查找选修“数据库技术”这门课程学生的学生名和成绩，若用关系代数表达式来表示为（）。A.ПSNAME, GRADE (σCNAME=’数据库技术’(C) ¥ПSNO, CNO, GRADE (SC) ¥ПSNO, SNAME (S) )#B.ПSNAME, GRADE (σCNAME=’数据库技术’(C) ¥ SC ¥ S)#C.ПSNAME, GRADE (C ¥ SC ¥ SC)#D.ПSNAME, GRADE (σCNAME=’数据库技术’ (ПCNAME (C)) ¥ПSNO, CNO, GRADE (SC) ¥ПSNO, SNAME (S) )
考题
在“学生-选课-课程”数据库中的3个关系如下：S（SNO, SNAME, SEX, AGE）； C（CNO, CNAME, TEACHER）；SC（SNO, CNO, GRADE），查找选修“数据库技术”这门课程学生的学生名和成绩，若用关系代数表达式来表示为（）。A.ПSNAME, GRADE (σCNAME=’数据库技术’(C) ¥SC ¥ПSNO, SNAME (S) )#B.ПSNAME, GRADE (σCNAME=’数据库技术’(C) ¥ SC ¥ S)#C.ПSNAME, GRADE (C ¥ SC ¥ SC)#D.ПSNAME, GRADE (σCNAME=’数据库技术’ (ПCNO, CNAME (C)) ¥ПSNO, CNO, GRADE (SC) ¥ПSNO, SNAME (S) )
考题
9、关于以下快捷查询的方法实现的查询条件是？ $User = M（"homeworkStatistics"); $map['uid|course_id'] = '251314'; // 把查询条件传入查询方法 $User-where（$map)-select（);A．uid|course_id = '251314'B．uid= 'thinkphp' AND course_id '251314'C．uid= 'thinkphp' AND course_id = '251314'D．uid= 'thinkphp' OR course_id = '251314'
考题
关于以下快捷查询的方法实现的查询条件是？ $User = M（"homeworkStatistics"); $map['uid|course_id'] = '251314'; // 把查询条件传入查询方法 $User-＞where（$map)-＞select（);A．uid|course_id = '251314'B．uid= 'thinkphp' AND course_id ＜ ＞ '251314'C．uid= 'thinkphp' AND course_id = '251314'D．uid= 'thinkphp' OR course_id = '251314'
热门标签
最新试卷
