单项选择题
下列各题基于以下描述：有关系模式P(A,B,C,D,E,F,G,H,I,J)，根据语义有如下函数依赖集：F={ABD→E,AB→G,B→F,C→J,C→I,G→H}
A．不具有无损连接性，不保持函数依赖 B．具有无损连接性，不保持函数依赖 C．不具有无损连接性，保持函数依赖 D．具有无损连接性且保持函数依赖
A．SELECT S# FROM SC GROUP BY S# WHERE COUNT(*)＞3 B．SELECT S# FROM SC GROUP BY S# HAVING COUNT(*)＞3 C．SELECT S# FROM SC ORDER BY S# HAVlNG COUNT(*)＞3 D．SELECT S# FROM SC ORDER BY S# WHERE COUNT(*)＞3