《数据库系统原理教学课件》作业讲评.pptxVIP

1作业讲评

26.2.2a01硬盘容量至少30G的笔记本电脑制造商及该电脑的速度添加标题02SELECTmaker,PC.model,speed添加标题03FROMProduct,Laptop添加标题04WHEREProduct.model=Laptop.model添加标题05ANDhd30添加标题

36.2.2a只生产至少30G硬盘笔记本电脑的制造商该电脑的速度添加标题(SELECTmaker,Laptop.model,speed添加标题FROMProduct,Laptop添加标题WHEREProduct.model=Laptop.modelANDhd=30)添加标题EXCEPT添加标题(SELECTmaker,Laptop.model,speed添加标题FROMProduct,Laptop添加标题WHEREProduct.model=Laptop.modelANDhd30)添加标题

46.2.2bB生产的所有产品的型号和价格1SELECTProduct.model,price2FROMProduct,Laptop,PC,Printer3WHEREmaker=‘B’AND4(Product.model=Laptop.modelOR5Product.model=PC.modelOR6Product.model=Printer.model)7WRONG8

56.2.2b(SELECTProduct.model,priceFROMProduct,PCWHEREmaker=‘B’ANDProduct.model=PC.model)UNION(SELECTProduct.model,priceFROMProduct,LaptopWHEREmaker=‘B’ANDProduct.model=Laptop.model)UNION(SELECTProduct.model,priceFROMProduct,PrinterWHEREmaker=‘B’ANDProduct.model=Printer.model)

66.2.2c只卖笔记本不卖PC的厂商01(SELECTDISTINCTmaker02FROMProduct03WHEREtype=‘Laptop’)04EXCEPT05(SELECTDISTINCTmaker06FROMProduct07WHEREtype=‘PC’)08

76.2.2d2SELECThd3FROMPC1出现在两种或两种以上PC中硬盘的大小5HAVINGCOUNT(*)=24GROUPBYhd

86.2.2d出现在两种或两种以上PC中硬盘的大小FROMPCP1,PCP2ANDP1.modelP2.modelSELECThdWHEREP1.hd=P2.hd(P1.modelP2.model?)

96.2.2e每对具有相同速度和内存的PC型号SELECTP1.model,P2.modelFROMPCP1,PCP2WHEREP1.speed=P2.speedANDP1.ram=P2.ramANDP1.modelP2.model

106.2.2f生产至少两种速度至少为3.0的电脑（PC或笔记本）的厂商

116.2.2fCREATEVIEWCOM(maker,model)AS((SELECTmaker,Product.modelFROMProduct,PCWHEREspeed=3.0ANDProduct.model=PC.model)UNION(SELECTmaker,Product.ModelFROMProduct,LaptopWHEREspeed=3.0ANDProduct.model=Laptop.model))

126.2.2f续添加标题SELECTmaker01添加标题GROUPBYmaker03添加标题FROMCOM02添加标题HAVINGCOUNT(*)=204

136.3.1a速度在3.0以上的PC的制造商01SELECTDISTINCTmaker02FROMProduct03WHEREmodelIN04(SELECTmodel05FROMPC06WHEREspeed3.0)07

146.3.1a添加标题速度在3.0以上的PC的制造商01添加标题SELECT