spring KXO102 复习重点.docx
- 文档编号:5842809
- 上传时间:2023-01-01
- 格式:DOCX
- 页数:17
- 大小:24.28KB
spring KXO102 复习重点.docx
《spring KXO102 复习重点.docx》由会员分享,可在线阅读,更多相关《spring KXO102 复习重点.docx(17页珍藏版)》请在冰豆网上搜索。
springKXO102复习重点
KXO102复习重点:
1.Whatisdataredundancy,andwhichcharacteristicsofthefilesystemcanleadto?
2.Whatisdataanomaly?
Whatarethethreedifferentdataanomalies?
3.WhatisaDBMS,andwhatareitsfunctions?
WhatistheroleofaDBMS?
4.Whatisrelationship?
Whatisconnectivity?
Whatiscardinality?
5.Whatarebusinessroles?
Policy,procedureorprinciples
6.Discusstheimportanceofdatamodeling?
7.Whataresuperkey,candidatekey,primarykey,andforeignkey?
8.Whataretheentityintegrityandreferentialintegrity?
9.whatismultivaluedattributeandhowtosolvethisproblem?
P109
10.Whataretheweakrelationshipsandstrongrelationships?
11.howtotransferaM:
Nrelationshiptothreeentities?
P126
12.whatisNormalization?
Whatare1NF,2NFAND3NF?
13.understandtheSQLinworkshop7and8.QBE
14.canuseupdate,insertintoandcreatetable.
15.whatisSDLCANDDBLC?
WhatactionsareinvolveinDBL?
P379
16.HowtoselectDBMSsoftware?
P394
17.Howtoprotectdatabasesecurity?
P399
18.Databasedesignstrategies,whatarethetop-downandbottom-updesign?
P402
19.Whatistransaction?
Andwhatarethetransactionproperties?
20.Whatisconcurrencycontrol?
21.Lockingmethods?
Lockgranularity?
Deadlockandmethodtocontrol.
22.Concurrencycontrolwithtimestampingmethods?
23.Concurrencycontrolwithoptimisticmethods?
24.Whatisdatawarehouse?
P564
25.DBASkills?
P615table15.2
26.ThemanagerialservicesandtechnicalroleofDBA?
P653
Considerthefollowingrelationaldatabasetablescontainingdetailsofanengineeringandconstructioncompanythathasafleetofvehiclesbasedatvariousdepots.Eachtypeofvehicleissoldaftersomanymonths(itsscheduledlifetime),andismaintainedatregularintervalsof1,2,or3monthsdependingonthevehicletype.
Tablename:
VEHICLE
Primarykey:
ID
Foreignkey:
TypeCode(linkstoTYPEtable)
Base(linkstoDEPOTtable)
ID
RegistrationNo
TypeCode
PurchaseDate
Make
Model
Base
251
ABC123
Car
27-Mar-2007
Ford
Ace
Hangzhou
252
PQR456
Truck
15-Jun-2006
Ford
Titan
Suzhou
253
ABC456
Truck
13-Feb-2007
Holden
Brute
254
PQR123
Car
27-Jun-2006
Toyota
Dragon
Wuxi
255
XYZ111
Car
28-Mar-2007
Ford
Flash
Hangzhou
256
ABC111
4WD
18-Apr-2005
Nissan
Titan
Suzhou
257
PQR111
Car
11-May-2006
Ford
Ace
Shanghai
258
XYZ456
Truck
25-Jan-2007
Holden
Brute
Hangzhou
259
XYZ123
4WD
14-Oct-2006
Nissan
Titan
Shanghai
Tablename:
DEPOT
Primarykey:
Location
Foreignkey:
None
Location
Manager
Phone
Suzhou
LiChen
64123456
Hangzhou
WenZhiang
64125718
Shanghai
HuWong
64126363
Tablename:
TYPE
Primarykey:
Code
Foreignkey:
None
Code
Lifetime
MaintenanceInterval
4WD
24
2
Car
36
3
Truck
48
1
Van
36
2
Question1
Arealltheprimarykeyswellchosen?
Table
Yes/No?
Explanation
VEHICLE
DEPOT
TYPE
[3marks]
Question2
Arealltheforeignkeyswellchosen?
Table
Yes/No/notapplicable?
Explanation
VEHICLE
DEPOT
TYPE
Question3
Arethereanycandidatekeysthatwerenotchosenastheprimarykey?
Table
Candidatekey
Explanation
VEHICLE
DEPOT
TYPE
Question4
Identify,wherepresent,anexampleofeachofthefollowingrelationshiptypes?
Table
PresentYes/No?
Details
One-to-one
One-to-many
Many-to-many
Question5
Whatdatatypeswouldyouchooseforeachofthefollowingattributes,andwhy?
Attribute
Datatype
Explanation
Liftetime
ID
Code
Question6
GivetheSQLstatementstocarryoutthefollowingoperations?
A.CreatetheDEPOTtable
B.AddanewvehicleTYPEcalledSemi-trailerwithamaintenanceIntervalof3monthsandalifetimeof60months
C.Countthenumberofvehiclesofeachtype.
Question7
DrawanERdiagram(usingtheCrow’sFootnotation)forthetables,showingallentities,relationshipsandattributes:
Question8
Brieflydescribethreedifferenttechniques/sourcesbywhichinformationmaybegatheredpriortodevelopingaconceptualmodel.
Question9
Considerthefollowingscenario:
Acustomermayownseveralcars,whichtheybringintoJoe’sGarageforservicingundertheirmanufacturer’swarranty.
Fortwoyearsformtheoriginaldatefopurchase,thevehiclemustbeservicedatthreemonthlyintervalsorthewarrantyisliabletobecancelled.
Thegaragesendsoutnoticestothecustomerjustbeforeeachvehicleisdueforitsnextservice.
Oneachservice,acustomerisgivenalistofpartsused,includingtheirdescriptionandcost,andisalsochargedforthenumberofhoursoflabourinvolved.
AllpartsusedaresuppliedfromJoe’sstoresdepartment,whichmaintiansaseparatedatabasefordealingwithitssuppliers.
Giventhisscenario:
a).Statethreerelevantbusinessrules
[6marks]
b).Identifythreepotentialentities,andforeachonegivesometypicalhypotheticaldatafortheentity’sattributes
c)Describethreerelationships.
d)d)Basedontheabove,drawaconceptualmodelusingeitheranERdiagramoraUMLclassdiagram.
Question10.
Describlethedesirableskillsforadatabaseadministrator.
Question11.
Describlewhatismeantbyatransaction.DescribeonetechniqueusedbyDBMSsoftwaretoensurethatconcurrenttransactionsdonotintreferewitheachother.
Question12.
Whatisthepurposeofnomalisingtablesforarelationaldatabase?
Question13
Whencomparingdatabasesoftwareforpurchasebyanorganisation,whatfeaturesareimportantindecidingwhichtobuy?
非考试重点,请尽量能理解下面的语句。
SectionB–QueryingRelations
AttemptALLquestionsfromSectionB.SectionBisworthatotalof20Marks.
Assumethatyouhaveaccesstoarelationaldatabasethatconsistsofthefollowingthreetables:
Member(Id,Name,Address,Date_of_birth,Gender)
Sport(Code,Name,Description)
Club(Name,Description)
Is_member_of(Member_Id,Club_name,Grade)
Is_playing(Club_name,Sport_Code)
Aregisteriskeptofthemembersofanumberofsportingclubs.EachMembercanbelongtooneormoreoftheseclubs.MembersaregradedasFull,AssociateandAffiliate,dependingonthetheirlevelofinvolvementandthefeepaidtoeachclub.EachClubisinvolvedinplayinganumberofsports,identifiedbySportCodes.
Question4
ExplainthemeaningofthefollowingSQLqueries:
a.SELECT*
FROMMember
WHEREGender="Female";
[2Marks]
∙Question4a-SampleAnswer:
(Answersareindicationsonlyofthetypeofanswerexpected–theyarenotcompleteanswers)
∙SelectanddisplayallcolumnsofthefemalemembersfromtheMembertable.
b.SELECTMember_Id
FROMIs_member_of
WHEREClub_nameLIKE"South*";
[2Marks]
∙Question4b-SampleAnswer:
(Answersareindicationsonlyofthetypeofanswerexpected–theyarenotcompleteanswers)
∙SelectanddisplaytheId'sofmembersofthoseclubswithnamesthatbeginwiththestring"South".
c.SELECTMember.Name,Gender,Club_name
FROMMember,Is_member_of
WHEREMember.Id=Is_member_of.Member_Id
ANDGrade="Full"
ANDDate_of_birth<"30-Jun-80";
[2Marks]
∙Question4c-SampleAnswer:
(Answersareindicationsonlyofthetypeofanswerexpected–theyarenotcompleteanswers)
∙Selectanddisplaythenamesofmembers,theirgenderandtheclubsinwhichtheyaremembers,formembersthathavefullmembershipintheseclubs,andwhowerebornbeforethe30thJune1980.
d.SELECTClub_name,Count(*)
FROMIs_member_of,Member
WHEREMember_Id=Is_member_of.Member_Id
ANDGender="Female"
GROUPBYClub_name;
[2Marks]
∙Question4d-SampleAnswer:
(Answersareindicationsonlyofthetypeofanswerexpected–theyarenotcompleteanswers)
∙Selectanddisplaythenamesofclubsandthecountsoffemalemembersinthoseclubs.Onlyincludethoseclubsthathaveatleastonefemalemember.
e.SELECTId,Name
FROMMember
WHEREIdIN
(SELECTMember_Id
FROMIs_member_of
WHEREClub_nameIN
(SELECTClub_name
FROMIs_playing
WHERESport_code="Netball");
[2Marks]
∙Question4e-SampleAnswer:
(Answersareindicationsonlyofthetypeofanswerexpected–theyarenotcompleteanswers)
∙SelectanddisplaytheId'sandnamesofmembersofclubsthatarerecordedasplayingNetball.
Question5(Multiple-ChoiceQuestions)
Foreachquestionselecttheanswerthatismostappropriate.Thelettercorrespondingtoyourselectedanswershouldbewrittenonthesheetprovidedatthebackofthisexaminationpaper.Theanswersheetmusthaveyourstudentnumberonitandberemovedfromtherestoftheexamsheetsandattachedtoyouranswerbook.
Member(Id,Name,Address,Date_of_birth,Gender)
Sport(Code,Name,Description)
Club(Name,Description)
Is_member_of(Member_Id,Club_name,Grade)
Is_playing(Club_name,Sport_Code)
Usingthesamerelationaltableasforquestion4(above),considerasituationinwhichauserperformseachofthefollowingcommands.Whaterrorsmightbeintroducedintothedatabasebyeachofthesecommands?
a.UPDATESport
SETCode="Rugby"
WHEREDescription="RugbyUnion";
(A)MayattempttoupdatemultiplerecordsinthetableClubtablewithduplicatekeyvalues
(B)UpdatingthevalueofCodemayleaveinvalidreferencesinothertables.
(C)ThecommandwillonlyworkiftheIs_playingtableisempty.
(D)Alloftheabove.
[2Marks]
∙Question5a-Answer:
B
(BriefExplanation–notneededfortheexam)
∙CodeistheprimarykeyattributeofthetableSport.ThisupdatemayattempttocreatemultiplerecordsinthetableSportwithduplicatekeyvaluesofCode
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- spring KXO102 复习重点 复习 重点