当前位置: X题卡 > 所有题目 > 题目详情

关系模式Student(Sno、Sname、Cno、Cname、Grade、Tname、Taddress)的属性分别表示学号、学生姓名、课程号、课程名、成绩、任课教师名和教师地址。其中,一个学生可以选...

查看本题答案

你可能感兴趣的试题

(Sno,Tno)和{Cno,Cname,Grade,Tno,Tname}  (Sno, Cno, Tno)和{Sno, Sname, Sex, Birthday, Cno}  (Sno, Cno)和{Sno, Sname, Sex, Birthday, Cno, Cname, Grade}  (Sno, Cno, Tno)和{Sno, Sname, Sex, Birthday, Tno, Tname}  
(Sno,Tno)和Cno,Cname,Grade,Tno,Tname  (Sno, Cno,Tno) 和Sno, Sname, Sex, Birthday, Cno  (Sno, Cno)和Sno, Sname, Sex, Birthday, Cno, Cname, Grade  (Sno, Cno,Tno)和Sno, Sname, Sex, Birthday, Tno, Tname  
1 个,为(Sno,Cno)  1 个,为(Sno,Cno,Tname)  2 个,为(Sno,Sname,Cno)和(Sno,Cno,Tname)  2 个,为(Sno,Sname,Cno)和(Sname,Cno,Tname)  
1个,为 (Sno, Cno)  1个,为 (Sno, Cno, Tname)  2个,为 (Sno, Sname, Cno) 和 (Sno, Cno, Tname)  2个,为 (Sno, Sname, Cno) 和 (Sname, Cno, Tname)  
(Sno,Sname,Cno,Tname,Taddr),(Sno,Sname,Cno,Cname,Grade)∈1NF  (Sno,Sname),(Sno ,Cno ,Grade,Tname,Taddr),(Cno,Cname)∈2NF  (Sno ,Sname),(Sno ,Cno ,Grade),(Tname,Taddr),(Cno ,Cname,)∈3NF  (Sno,Sname),(Sno,Cno,Grade),(Tname,Taddr),(Tname,Cno),(Cno,Cname)∈BCNF  
1个,为(Sno,Cno)  1个,为(Sno,Cno,Tname)  2个,为(Sno,Sname,Cno)和(Sno,Cno,Tname)  2个,为(Sno,Sname,Cno)和(Sno,Cno,Tnam  
(Sno,Tno)和{Cno,Cname,Grade,Tno,Tname}  (Sno, Cno,Tno) 和{Sno, Sname, Sex, Birthday, Cno}  (Sno, Cno)和{Sno, Sname, Sex, Birthday, Cno, Cname, Grade}  (Sno, Cno,Tno)和{Sno, Sname, Sex, Birthday, Tno, Tname}  
{(Sno,Sname,Cno,Tname,Tadd,(Sno,Sname,Cno,Cname,Grad)属于2NF  {(Sno,Snam,(Sno,Cno,Grade Tname,Tadd,(Cno,Cnam}属于2NF  {(Sno,Snam,(Sno,Cno,Grad,(Tname,Tadd,(Cno,Cnam}属于3NF  {(Sno,Snam,(Sno,Cno,Grad,(Tname,Tadd,(Tname,Cn,(Cno,Cnam}属于3NF  
(Sno,Sname,Cno,Tname,Taddr),(Sno,Sname,Cno,Cname,Grad为1NF  (Sno,Snam,(Sno,Cno,Grade,Tname,Taddr),(Cno,Cnam为2NF  (Sno,Snam,(Sno,Cno,Grad,(Tname,Taddr),(Cno,Cnam)为3NF  (Sno,Snam,(Sno,Cno,Grad,(Tname,Taddr),(Tname,Cno),(Cno,Cnam为BCNF、  
(Sno,Sname,Cno,Tname,Taddr),(Sno,Sname,Cno,Cname,Grade)为1NF  (Sno,Sname),(Sno,Cno,Grade,Tname,Taddr),(Cno,Cname)为2NF  (Sno,Sname),(Sno,Cno,Grade),(Tname,Taddr),(Cno,Cname))为3NF  (Sno,Sname),(Sno,Cno,Grade),(Tname,Taddr),(Tname,Cno),(Cno,Cname)为BCNF、  
(Sno,Tno)和Cno,Cname,Grade,Tno,Tname  (Sno,Cno,Tno)和Sno,Sname,Sex,Birthday,Cno  (Sno,Cno)和Sno,Shame,Sex,Birthday,Cno,Cname,Grade  (Sno,Cno,Tno)和Sno,Sname,Sex,Birthdayr,Tno,Tname  
{(Sno, Sname, Cno, Tname, Taddr), (Sno, Sname, Cno, Cname, Grade) } ∈ 2NF  {(Sno, Shame), (Sno, Cno, Grade, Tname, Taddr), (Cno, Cname)}∈ 2NF  {(Sno, Sname), (Sno, Cno, Grade), (Tname, Taddr), (Cno, Cname) } ∈ 3NF  {(Sno, Sname), (Sno, Cno, Grade), (Tname, Taddr), (Tname, Cno), (Cno, Cname)}∈3NF  
1个,为 (Sno, Cno)  1个,为 (Sno, Cno, Tname)  2个,为 (Sno, Sname, Cno) 和 (Sno, Cno, Tname)  2个,为 (Sno, Sname, Cno) 和 (Sname, Cno, Tname)  
{(Sno,Sname,Cno,Tname,Tadd,(Sno,Sname,Cno,Cname,Grad}∈1NF  {(Sno,Snam,(Sno,Cno,Grade,Tname,Tadd,(Cno,Cnam}∈i2NF  {(Sno,Snam,(Sno,Cno,Grad,(Tname,Tadd,(Cno,Cname,)∈3NF  {(Sno,Snam,(Sno,Cno,Grad,(Tname,Tadd,(Tname,Cn,(Cno,Cnam}∈BCNF  
(Sno,Sname,Cno,Tname,Taddr),(Sno,Sname,Cno,Cname,Grade))∈1NF  (Sno,Sname),(Sno,Cno,Grade,Tname,Taddr),(Cno,Cname))∈2NF  (Sno,Sname),(Sno,Cno,Grade),(Tname,Taddr),(Cno,Cname))∈3NF  f(Sno,Sname),(Sno,Cno,Grade),(Tname,Taddr),(Tname,Cno),(Cno,Cname))∈BCNF  
(Sno,Sname,Cno,Tname,Taddr),(Sno,Sname,Cno,Cname,Grad属于1NF  (Sno,Snam,(Sno,Cno,Grade,Tname,Taddr),(Cno,Cnam属于2NF  (Sno,Snam,(Sno,Cno,Grad,(Tname,Taddr),(Cno,Cnam属于3NF  (Sno,Snam,(Sno,Cno,Grad,(Tname,Taddr),(Tname,Cno),(Cno,Cnam属于BCNF  

热门试题

更多