在“學(xué)生-選課-課程”數(shù)據(jù)庫(kù)中的3個(gè)關(guān)系如下:S(SNO, SNAME, SEX, AGE);SC(SNO, CNO, GRADE); C(CNO, CNAME, TEACHER),查找選修“數(shù)據(jù)庫(kù)技術(shù)”這門課程學(xué)生的學(xué)生名和成績(jī),若用關(guān)系代數(shù)表達(dá)式來(lái)表示為(? )。A.ПCNAME, GRADE (σCNAME=’數(shù)據(jù)庫(kù)技術(shù)’(C) ¥ПSNO, CNO, GRADE (SC) ¥ПSNO, SNAME (S) )B.ПCNAME, GRADE (σCNAME=’數(shù)據(jù)庫(kù)技術(shù)’(C) ¥ SC ¥ SC)C.ПCNAME, GRADE (C ¥ SC ¥ SC)D.ПCNAME, GRADE (σCNAME=’數(shù)據(jù)庫(kù)技術(shù)’ (ПCNAME (C)) ¥ПSNO, CNO, GRADE (SC) ¥ПSNO, SNAME (S) )
急急急!求大神解答?。?/h1>
yuantongxin
2016-04-28 22:24:14
yuantongxin
2016-04-28 22:24:14