数据库系统第2章.pptVIP

求获得‘c1’课最高分的学生学号. πSno (бCno= c1 (Enrollment) ) - πE1.Sno (ρE1(Enrollment) ρE2 (Enrollment)) E1.Score E2.Score AND E1.Cno =‘c1’ AND E2.Cno =‘c1’ Enrollment E1 E2 E1.Sno E1.Cno E1.Score E2.Sno E2.Cno E2.Score 01 c1 80 02 c1 90 03 c1 75 01 c1 80 03 c1 75 02 c1 90 Sno Cno Score 01 c1 80 03 c1 75 01 c2 78 02 c1 90 Sno Cno Score 01 c1 80 03 c1 75 01 c2 78 02 c1 90 2.4.14 Example Customer (custid, name, prov, city, phone, company) ?Product (prodid, factory, type, sp