管理信息系统（精要版·第14版） 课件 第6章商务智能基础：数据库与信息管理.pptx

EssentialsofManagementInformationSystemsFourteenthEditionChapter6FoundationsofBusinessIntelligence:DatabasesandInformationManagementCopyright?2021,2019,2017PearsonEducation,Inc.AllRightsReserved

LearningObjectives6.1Whatisadatabase,andhowdoesarelationaldatabase organizedata?6.2Whataretheprinciplesofadatabasemanagement system?6.3Whataretheprincipaltoolsandtechnologiesfor accessinginformationfromdatabasestoimprove businessperformanceanddecisionmaking?6.4?Whyareinformationpolicy,dataadministration,anddata qualityassuranceessentialformanagingthefirm’sdata resources?6.5?HowwillMIShelpmycareer?

VideoCasesCase1:DubuqueUsesCloudComputingandSensorstoBuildaSmarterCityCase2:BrooksBrothersClosesinonOmnichannelRetailCase3:MarutiSuzukiBusinessIntelligenceandEnterpriseDatabases

Domino’sMastersDataOnePizzaAtATimeProblemVerylargevolumeofdataDatafragmentedinmultiplesystemsandfilesSolutionsDeployTalendDeployMDMSoftwareDeployHadoopIllustratestheimportanceofdatamanagementforbetterdecisionmakingandcustomeranalysis

WhatIsaDatabase?Database:Collectionofrelatedfilescontainingrecordsonpeople,places,orthingsEntity:Generalizedcategoryrepresentingperson,place,thingE.g.,SUPPLIER,PARTAttributes:Specificcharacteristicsofeachentity:SUPPLIERname,addressPARTdescription,unitprice,supplier

RelationalDatabasesOrganizedataintotwo-dimensionaltables(relations)withcolumnsandrowsOnetableforeachentity:E.g.,(CUSTOMER,SUPPLIER,PART,SALES)Fields(columns)storedatarepresentinganattributeRowsstoredataforseparaterecords,ortuplesKeyfield:uniquelyidentifieseachrecordPrimarykey

Figure6.2ARelationalDatabaseTable

Figure6.3ThePARTTable

EstablishingRelationships(1of2)Entity-relationshipdiagramUsedtoclarifytablerelationshipsinarelationaldatabaseRelationaldatabasetablesmayhave:One-to-one