数据库系统基础教程第二章答案Word文件下载.docx
- 文档编号:4444348
- 上传时间:2023-05-03
- 格式:DOCX
- 页数:30
- 大小:387.79KB
数据库系统基础教程第二章答案Word文件下载.docx
《数据库系统基础教程第二章答案Word文件下载.docx》由会员分享,可在线阅读,更多相关《数据库系统基础教程第二章答案Word文件下载.docx(30页珍藏版)》请在冰点文库上搜索。
)
Customers(
firstName,
lastName,
idNo,
account
Exercisesuitabledomainforeachattribute:
acctNoInteger
typeString
balanceInteger
firstNameString
lastNameString
idNoString(becausethereisahyphenwecannotuseInteger)
accountInteger
ExerciseequivalentwaytopresenttheAccountrelation:
acctNo
balance
type
34567
25
savings
23456
1000
checking
12345
12000
AnotherequivalentwaytopresenttheCustomersrelation:
idNo
firstName
lastName
account
805-333
Lena
Hand
901-222
Robbie
Banks
Exerciseofattributesthatarecreatedforprimarilyservingaskeysinarelation:
UniversalProductCode(UPC)usedwidelyinUnitedStatesandCanadatotrackproductsinstores.
SerialNumbersonawidevarietyofproductstoallowthemanufacturertoindividuallytrackeachproduct.
VehicleIdentificationNumbers(VIN),auniqueserialnumberusedbytheautomotiveindustrytoidentifyvehicles.
Exercisecanorderthethreetuplesinanyof3!
=6ways.Also,thecolumnscanbeorderedinanyof3!
=6ways.Thus,thenumberofpresentationsis6*6=36.
Exercisecanorderthethreetuplesinanyof5!
=120ways.Also,thecolumnscanbeorderedinanyof4!
=24ways.Thus,thenumberofpresentationsis120*24=2880
Exercisecanorderthethreetuplesinanyofm!
ways.Also,thecolumnscanbeorderedinanyofn!
ways.Thus,thenumberofpresentationsisn!
m!
ExerciseTABLEProduct(
makerCHAR(30),
modelCHAR(10)PRIMARYKEY,
typeCHAR(15)
);
ExerciseTABLEPC(
modelCHAR(30),
speedDECIMAL(4,2),
ramINTEGER,
hdINTEGER,
priceDECIMAL(7,2)
ExerciseTABLELaptop(
screenDECIMAL(3,1),
ExerciseTABLEPrinter(
colorBOOLEAN,
typeCHAR(10),
ExerciseTABLEPrinterDROPcolor;
ExerciseTABLELaptopADDodCHAR(10)DEFAULT‘none’;
ExerciseTABLEClasses(
classCHAR(20),
typeCHAR(5),
countryCHAR(20),
numGunsINTEGER,
boreDECIMAL(3,1),
displacementINTEGER
ExerciseTABLEShips(
nameCHAR(30),
launchedINTEGER
ExerciseTABLEBattles(
dateDATE
ExerciseTABLEOutcomes(
shipCHAR(30),
battleCHAR(30),
resultCHAR(10)
ExerciseTABLEClassesDROPbore;
ExerciseTABLEShipsADDyardCHAR(30);
Exercise
R1:
=σspeed≥(PC)
R2:
=πmodel(R1)
model
1005
1006
1013
ExerciseR1:
=σhd≥100(Laptop)
=Product
(R1)
R3:
=πmaker(R2)
maker
E
A
B
F
G
=σmaker=B(Product
PC)
Laptop)
Printer)
R4:
=πmodel,price(R1)
R5:
=πmodel,price(R2)
R6:
=πmodel,price(R3)
R7:
=R4
R5
R6
price
1004
649
630
1049
2007
1429
=σcolor=trueANDtype=laser(Printer)
=πmodel(R1)
3003
3007
=σtype=laptop(Product)
=σtype=PC(Product)
=πmaker(R1)
=πmaker(R2)
=R3–R4
=ρPC1(PC)
R2:
=ρPC2(PC)
R3:
=R1
=AND<
>
R2
R4:
=πhd(R3)
hd
250
80
160
=AND=AND<
R2
=π,(R3)
1012
=πmodel(σspeed≥(PC))
πmodel(σspeed≥(Laptop))
=πmaker,model(R1
Product)
=ρR3(maker2,model2)(R2)
=R2
(maker=maker2ANDmodel<
model2)R3
=πmaker(R4)
=πmodel,speed(PC)
=πmodel,speed(Laptop)
=ρR4(model2,speed2)(R3)
=πmodel,speed(R3
(speed<
speed2)R4)
R6:
=R3–R5
=πmaker(R6
=πmaker,speed(Product
=ρR2(maker2,speed2)(R1)
=ρR3(maker3,speed3)(R1)
(maker=maker2ANDspeed<
speed2)R2
(maker3=makerANDspeed3<
speed2ANDspeed3<
speed)R3
=πmaker(R5)
D
=πmaker,model(Product
=ρR2(maker2,model2)(R1)
=ρR3(maker3,model3)(R1)
=ρR4(maker4,model4)(R1)
R5:
model2)R2
R6:
=R3
(maker3=makerANDmodel3<
model2ANDmodel3<
model)R5
R7:
(maker4=makerAND(model4=modelORmodel4=model2ORmodel4=model3))R6
R8:
=πmaker(R7)
Exercise
=σbore≥16(Classes)
=πclass,country(R1)
class
country
Iowa
USA
NorthCarolina
Yamato
Japan
=σlaunched<
1921(Ships)
=πname(R1)
name
Haruna
Hiei
Kirishima
Kongo
Ramillies
Renown
Repulse
Resolution
Revenge
RoyalOak
RoyalSovereign
Tennessee
=σbattle=DenmarkStraitANDresult=sunk(Outcomes)
=πship(R1)
ship
Bismarck
Hood
=Classes
Ships
=σlaunched>
1921ANDdisplacement>
35000(R1)
=πname(R2)
Missouri
Musashi
NewJersey
Washington
Wisconsin
=σbattle=Guadalcanal(Outcomes)
=Ships
(ship=name)R1
=πname,displacement,numGuns(R3)
displacement
numGuns
32000
8
37000
9
=πname(Ships)
=πship(Outcomes)
=ρR3(name)(R2)
R3
California
Arizona
DukeofYork
Fuso
KingGeorgeV
PrinceofWales
Rodney
Scharnhorst
SouthDakota
WestVirginia
Yamashiro
ExerciseFromassumingthateveryclasshasoneshipnamedaftertheclass.
=πclass(Classes)
=πclass(σname<
class(Ships))
=R1–R2
=πcountry(σtype=bb(Classes))
=πcountry(σtype=bc(Classes))
=R1∩R2
Gt.Britain
=πship,result,date(Battles
(battle=name)Outcomes)
=ρR2(ship2,result2,date2)(R1)
(ship=ship2ANDresult=damagedANDdate<
date2)R2
=πship(R3)
Noresultsfromsampledata.
resultofthenaturaljoinhasonlyoneattributefromeachpairofequatedattributes.Ontheotherhand,theresultofthetheta-joinhasbothcolumnsoftheattributesandtheirvaluesareidentical.
ExerciseUnionweaddatupletotheargumentsoftheunionoperator,wewillgetallofthetuplesoftheoriginalresultandmaybetheaddedtuple.Iftheaddedtupleisaduplicatetuple,thenthesetbehaviorwilleliminatethattuple.Thustheunionoperatorismonotone.
Intersection
Ifweaddatupletotheargumentsoftheintersectionoperator,wewillgetallofthetuplesoftheoriginalresultandmaybetheaddedtuple.Iftheaddedtupledoesnotexistintherelationthatitisaddedbutdoesexistintheotherrelation,thentheresultsetwillincludetheaddedtuple.Thustheintersectionoperatorismonotone.
Difference
Ifweaddatupletotheargumentsofthedifferenceoperator,wemaynotgetallofthetuplesoftheoriginalresult.SupposewehaverelationsRandSandwearecomputingR–S.SupposealsothattupletisinRbutnotinS.TheresultofR–Swouldincludetuplet.However,ifweaddtuplettoS,thenthenewresultwillnothavetuplet.Thusthedifferenceoperatorisnotmonotone.
Projection
Ifweaddatupletotheargumentsoftheprojectionoperator,wewillgetallofthetuplesoftheoriginalresultandtheprojectionoftheaddedtuple.Theprojectionoperatoronlyselectscolumnsfromtherelationanddoesnotaffecttherowsthatareselected.Thustheprojectionoperatorismonotone.
Selection
Ifweaddatupletotheargumentsoftheselectionoperator,wewillgetallofthetuplesoftheoriginalresultandmaybetheaddedtuple.Iftheaddedtuplesatisfiestheselectcondition,thenitwillbeaddedtothenewresult.Theoriginaltuplesareincludedinthenewresultbecausetheystillsatisfytheselectcondition.Thustheselectionoperatorismonotone.
CartesianProduct
IfweaddatupletotheargumentsoftheCartesianproductoperator,wewillgetallofthetuplesoftheoriginalresultandpossiblyadditionaltuples.TheCartesianproductpairsthetuplesofonerelationwiththetuplesofanotherrelation.SupposethatwearecalculatingRxSwhereRhasmtuplesandShasntuples.IfweaddatupletoRthatisnotalreadyinR,thenweexpecttheresultofRxStohave(m+1)*ntuples.ThustheCartesianproductoperatorismonotone.
NaturalJoins
Ifweaddatupleto
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 数据库 系统 基础教程 第二 答案
![提示](https://static.bingdoc.com/images/bang_tan.gif)