ch01_01_Introduction数据库技术的英文课件

DAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-1DavidM.Kroenke’sChapterOne:IntroductionPartOneDatabaseProcessing:Fundamentals,Design,andImplementationDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-2ChapterObjectives•Todefinethetermdatabaseanddescribewhatiscontainedwithinthedatabase•Todefinethetermmetadataandprovideexamplesofmetadata•Todefineandunderstanddatabasedesign•TounderstandthehistoryanddevelopmentofdatabaseprocessingDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-3TheDefinitionofDatabases•Adatabaseisastructuredcollectionofrecordsordatathatisstoredinacomputersystem.–FlatModel–HierarchicalModel–NetworkModel–RelationalModel–…DAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-4TheRelationalDatabaseModel•Thedominantdatabasemodelistherelationaldatabasemodel–allcurrentmajorDBMSproductsarebasedonit•CreatedbyIBMengineerE.F.Coddin1970•Itwasbasedonmathematicscalledrelationalalgebra•ThistextexaminesandexplainstherelationaldatabasemodelDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-5ABriefHistoryofDatabaseProcessingDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-6TheCharacteristicsofDatabases•Thepurposeofadatabaseistohelppeopletrackthingsofinteresttothem•Dataisstoredintables,whichhaverowsandcolumnslikeaspreadsheet.–Adatabasemayhavemultipletables,whereeachtablestoresdataaboutadifferentthing•Eachrowinatablestoresdataaboutanoccurrenceorinstanceofthethingofinterest•AdatabasestoresdataandrelationshipsDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-7DatainTablesDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-8TheKeyCharacteristicofDatabases:RelatedTablesDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-9NamingConventionsinthisTextbook•TableNamesarewrittenwithallcapitalletters:–STUDENT,CLASS,GRADE•Columnnamesarewrittenwithaninitialcapitalletter,andcompoundnamesarewrittenwithacapitalletteroneachword:–Term,Section,ClassNumber,StudentNameDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-10ThefeaturesofDatabase•Adatabaseisaself-describingcollectionofintegratedtables–Thetablesarecalledintegratedbecausetheystoredataabouttherelationshipsbetweentherowsofdata–Adatabaseiscalledself-describingbecauseitstoresadescriptionofitself–Theself-describingdataarecalledmetadata,whichisdataaboutdata.DAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-11TypicalMetadataTablesDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-12DatabaseContentsDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-13DatabasesCreateInformation•Data=Recordedfactsandfigures•Information=Knowledgederivedfromdata•Databasesrecorddata,buttheydosoinsuchawaythatwecanproduceinformationfromthedata–ThedataonSTUDENTs,CLASSesandGRADEscouldproduceinformationabouteachstudent’sGPADAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-14DatabaseExamplesDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-15Applications,theDBMSandSQL•Applicationsarethecomputerprogramsthatusersworkwith.•TheDatabaseManagementSystem(DBMS)creates,processesandadministersdatabases.•StructuredQueryLanguage(SQL)isaninternationallyrecognizedstandarddatabaselanguagethatisusedbyallcommercialDBMSs.DAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-16ProminentDBMSProducts•MicrosoftAccess•MicrosoftSQLServer–New:MicrosoftSQLServerExpress•IBMDB2•OracleCorporationORACLE•Anddon’toverlookMySQLDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-17DBMSPowervs.EaseofUseDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-18ComponentsofaDatabaseSystem:MicrosoftAccessDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-19MSAccessinDetailDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-20Enterprise-ClassDatabaseSystemsDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-21WhatYouNeedtoLearnDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-22KnowledgePrioritiesDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-23DavidM.Kroenke’sDatabaseProcessingFundamentals,Design,andImplementation(10thEdition)EndofPresentation:ChapterOne-PartOneDAVIDM.KROENKE’SDATABASEPROCESSING,10thEdition©2006PearsonPrenticeHall1-24Homework1•了解MySQL数据库管理系统•写调研报告–诞生及版本演变历史–组成结构及主要功能–…•要求–中文–不少于1000字–3.8提交纸质报告