武漢理工大學(xué)數(shù)據(jù)庫系統(tǒng)原理總復(fù)習(xí)題完整版含答案

1、1武漢理工大學(xué)武漢理工大學(xué)數(shù)據(jù)庫系統(tǒng)原理總復(fù)習(xí)題（完整版含答案）數(shù)據(jù)庫系統(tǒng)原理總復(fù)習(xí)題（完整版含答案）1.Questions1.1WhatisthepurposeofadatabaseANSWER：Thepurposeofadatabaseistohelppeopletrackofthings.1.2WhatisthemostcommonlyusedtypeofdatabaseANSWER:themostcommonlyusedtype

2、ofdatabaseistherelationaldatabase.1.7Definethetermsdatainfmation.Explainhowthetwotermsdiffer.ANSWER:Dataarerecdedfactsnumbers.wecannowdefineinfmationas:?Knowledgederivedfromdata.?Datapresentedinameaningfulcontext.?Datapr

3、ocessedbysummingderingaveraginggroupingcomparingothersimilaroperations.1.10WhatproblemcanoccurwhenadatabaseisprocessedbymethanoneuserANSWER:Whenmethanoneuseremploysadatabaseapplicationtheseisalwaysthechancethatoneuserswk

4、mayinterferewithothers.1.12WhatisthepurposeofthelargestdatabasesatecommercecompaniessuchasANSWER:Thelargestdatabasesarethosethattrackcustomerbrowserbehavi.（用來記錄用戶的瀏覽行為的。）1.13Howdotheecommercecompaniesusethesedatabases.AN

5、SWER:EcommercecompaniesuseWebactivitydatabasestodeterminewhichitemsonaWebpagearepopularsuccessfulwhicharenot.1.14HowdodigitaldashboarddataminingapplicationsdifferfromtransactionprocessingapplicationsANSWER:Digitaldashboa

6、rdsotherreptingsystemsassesspastcurrentperfmance.Dataminingapplicationspredictfutureperfmance.1.15Explainwhyasmalldatabaseisnotnecessarilysimplerthanalargeone.WhatarethefunctionsofapplicationprogramsANSWER:Supposedwehave

7、2companywhicharedifferentinsalesbuthavesimilardatabase.Thoughthedifferenceinsalebothhavethesamekindsofdataaboutthesamenumberoftablesofdatathesamelevelofcomplexityindatarelationships.Onlytheamountofdatavariesfromonetotheo

8、ther.Thusalthoughadatabasefasmallbusinessmaybesmallitisnotnecessarilysimple.31.27IsMicrosoftAccessaDBMSWhywhynotANSWER:NoMicrosoftAccessisnotjustaDBMS.Ratheritisapersonaldatabasesystem:aDBMSplusanapplicationgenerat.Becau

9、sealthoughMicrosoftAccesscontainsaDBMSenginethatcreatesprocessesadministersthedatabaseitalsocontainsfmreptquerycomponentsthataretheMicrosoftAccessapplicationgenerat1.37Listseveralconsequencesofapolydesigneddatabase.ANSWE

10、R:TheymayrequireapplicationdeveloperstowriteoverlycomplexcontrivedSQLtoget–wanteddata.theymaybedifficulttoadapttonewchangingrequirements.theymayfailinsomeotherway.1.38Explaintwowaysthatadatabasecanbedesignedfromexistingd

11、ata.ANSWER:ThefirsttypeofdatabasedesigninvolvesdatabasesthatareconstructedfromexistingData.Asecondwaythatdatabasesaredesignedisfthedevelopmentofnewinfmationsystems.1.39WhatisadatawarehouseWhatisadatamartANSWER:Thedatawar

12、ehousedatamartdatabasesstedataspecificallyganizedfresearchreptingpurposesthesedataoftenareexptedtootheranalyticaltoolssuchasSAS’sEnterpriseMinerIBMsSPSSDataModelerTIBCOsSpotfireMetrics.1.40Describethegeneralprocessofdesi