数据库系统基础教程第七章答案Word文件下载.doc
- 文档编号:13168964
- 上传时间:2022-10-07
- 格式:DOC
- 页数:17
- 大小:64.50KB
数据库系统基础教程第七章答案Word文件下载.doc
《数据库系统基础教程第七章答案Word文件下载.doc》由会员分享,可在线阅读,更多相关《数据库系统基础教程第七章答案Word文件下载.doc(17页珍藏版)》请在冰豆网上搜索。
or
producerC# INT REFERENCESMovieExec(cert#),
PRIMARYKEY(title,year)
b)
producerC# INT REFERENCESMovieExec(cert#)
ONDELETESETNULL
ONUPDATESETNULL,
c)
ONDELETECASCADE
ONUPDATECASCADE,
d)
CREATETABLEStarsIn(
movieTitle CHAR(100)REFERENCESMovie(title),
movieYear INT,
starName CHAR(30),
PRIMARYKEY(movieTItle,movieYear,starName)
e)
movieTitle CHAR(100)REFERENCESMovie(title)
ONDELETECASCADE,
7.1.2
Todeclaresuchaforeign-keyconstraintbetweentherelationsMovieandStarsIn,valuesofthereferencingattributesinMovieshouldappearinMovieStarasuniquevalues.However,basedonprimarykeydeclarationinrelationStarIn,theuniquenessofmoviesisguaranteedwithmovieTitle,movieYear,andstarNameattributes.EvenwithtitleandyearasreferencingattributesthereisnowayofreferencinguniquemoviefromStarsInwithoutstarNameinformation.Therefore,suchaconstraintcannotbeexpressedusingaforeign-keyconstraint.
7.1.3
ALTERTABLEProduct
ADDPRIMARYKEY(model);
ALTERTABLEPC
ADDFOREIGNKEY(model)REFERENCESProduct(model);
ALTERTABLELaptop
ADDFOREIGNKEY(model)REFERENCESProduct(model);
ALTERTABLEPrinter
7.1.4
ALTERTABLEClasses
ADDPRIMARYKEY(class);
ALTERTABLEShips
ADDPRIMARYKEY(name);
ADDFOREIGNKEY(class)REFERENCESClasses(calss);
ALTERTABLEBattles
ALTERTABLEOutcomes
ADDFOREIGNKEY(ship)REFERENCESShips(name);
ADDFOREIGNKEY(battle)REFERENCESBattles(name);
7.1.5
ADDFOREIGNKEY(class)REFERENCESClasses(class)
ONDELETESETNULL
ONUPDATESETNULL;
Inadditiontotheabovedeclaration,classmustbedeclaredtheprimarykeyforClasses.
ALTERTABLEOutcome
ADDFOREIGNKEY(battle)REFERENCESBattles(name)
ONDELETESETNULL
ONUPDATESETNULL;
ADDFOREIGNKEY(ship)REFERENCESShips(name)
ONDELETESETNULL
ONUPDATESETNULL;
7.2.1
year INT CHECK(year>
=1915)
length INT CHECK(length>
=60ANDlength<
=250)
studioName CHAR(30)
CHECK(studioNameIN(‘Disney’,Fox’,‘MGM’,‘Paramount’))
7.2.2
CREATETABLELaptop(
…
speed DECIMAL(4,2) CHECK(speed>
=2.0)
…
CREATETABLEPrinter(
type VARCHAR(10)
CHECK(typeIN(‘laser’,‘ink-jet’,‘bubble-jet’))
CREATETABLEProduct(
type VARCHAR(10)
CHECK(typeIN(‘pc’,‘laptop’,‘printer’))
model CHAR(4)
CHECK(modelIN(SELECTmodelFROMPC
UNIONALL
SELECTmodelFROMlaptop
SELECTmodelFROMprinter))
*notethisdoesn’tchecktheattributeconstraintviolationcausedbydeletionsfromPC,laptop,orprinter
7.2.3
starNameCHAR(30)
CHECK(starNameIN(SELECTnameFROMMovieStar
WHEREYEAR(birthdate)>
movieYear))
CREATETABLEStudio(
addressCHAR(255) CHECK(addressISUNIQUE)
CREATETABLEMovieStar(
nameCHAR(30) CHECK(nameNOTIN(SELECTnameFROMMovieExec))
NameCHAR(30) CHECK(nameIN(SELECTstudioNameFROMMovies))
CHECK(producerC#NOTIN(SELECTpresC#FROMStudio)OR
studioNameIN(SELECTnameFROMStudio
WHEREpresC#=producerC#))
7.2.4
CHECK(speed>
=2.0ORprice<
=600)
CHECK(screen>
=15ORhd>
=40ORprice<
=1000)
7.2.5
CHECK(classNOTIN(SELECTclassFROMClasses
WHEREbore>
16))
CHECK(classNOTIN(SELECTclassFROMClasses
WHEREnumGuns>
9ANDbore>
14))
c)
CHECK(shipIN(SELECTs.nameFROMShipss,Battlesb,Outcomeso
WHEREs.name=o.shipAND
b.name=o.batt
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 数据库 系统 基础教程 第七 答案