国外计算机科学教材系列：数据库处理：基础、设计与实现（第11版）（英文版）

图书标准信息

• 作者 [美]克罗恩克、[美]奥尔 著
• 出版社 电子工业出版社
• 出版时间 2010-07
• 版次 1
• ISBN 9787121112416
• 定价 75.00元
• 装帧 平装
• 开本 16开
• 纸张 胶版纸
• 页数 607页
• 正文语种 英语

【内容简介】

《数据库处理：基础、设计与实现（第11版）（英文版）》从基础、设计和实现三个层面介绍数据库处理技术，内容全面翔实，既包括数据库设计、数据库实现、多用户数据处理、数据访问标准等经典理论，也包括商务智能、XML和NET等最新技术。《数据库处理：基础、设计与实现（第11版）（英文版）》在内容编排和写作风格上新颖，强调学习过程中的乐趣，围绕两个贯穿全书的项目练习，让读者从一开始就能把所学的知识用于解决具体的应用实例。
《数据库处理：基础、设计与实现（第11版）（英文版）》每章都有丰富的习题，可作为高校本科生或研究生的数据库课程的双语教材，同时也是一本很好的专业参考书。

【作者简介】

作者：（美国）克罗恩克（DavidM.Kroenke）（美国）奥尔（DavidAuer）

【目录】

Prefacexvii
PART1GETTINGSTARTED
Chapter1：Introduction
ChapterObjectives
TheCharacteristicsofDatabases
ANoteonNamingConventions
ADatabaseHasDataandRelationships
DatabasesCreateInformation
DatabaseExamples
Single-UserDatabaseApplications
MultiuserDatabaseApplications
E-CommerceDatabaseApplications
ReportingandDataMiningDatabaseApplications
TheComponentsofaDatabaseSystem
DatabaseApplicationsandSQL
TheDBMS
TheDatabase
PersonalVersusEnterprise-ClassDatabaseSystems
WhatIsMicrosoftAccess?
WhatIsanEnterprise-ClassDatabaseSystem?
DatabaseDesign
DatabaseDesignfromExistingData
DatabaseDesignforNewSystemsDevelopment
DatabaseRedesign
WhatYouNeedtoLearn
ABriefHistoryofDatabaseProcessing
TheEarlyYears
TheEmergenceandDominanceoftheRelationalModel
Post-RelationalDevelopments
Summary
KeyTerms
ReviewQuestions
ProjectQuestions
Chapter2：IntroductiontoStructuredQueryLanguage
ChapterObjectives
CapeCoddOutdoorSports
TheRetailSalesDataExtraction
RETAIL_ORDERData
ORDERITEMData
SKU_DATATable
DataExtractsAreCommon
SQLBackground
TheSQLSELECT/FROM/WHEREFramework
ReadingSpecifiedColumnsfromaSingleTable
ReadingSpecifiedRowsfromaSingleTable
ReadingSpecifiedColumnsandRowsfromaSingleTable
SubmittingSQLStatementstotheDBMS
UsingSQLinMicrosoftAccess2007
UsingSQLinMicrosoftSQLServer2008
UsingSQLinOracleDatabase11g
UsingSQLinSunMicrosystemsMySQL5.1
SQLEnhancementsforQueryingaSingleTable
SortingtheResults
SQLWHEREClauseOptions
CombingtheSQLWHEREClauseandtheSQLORDERBYClause
PerformingCalculationsinSQLQueries
UsingSQLBuilt-inFunctions
SQLExpressionsinSQLSELECTStatements
GroupinginSQLSELECTStatements
LookingforPatternsinNASDAQTrading
InvestigatingtheCharacteristicsoftheData
SearchingforPatternsinTradingbyDayofWeek
QueryingTwoorMoreTableswithSQL
QueryingMultipleTableswithSubqueries
QueryingMultipleTableswithJoins
ComparingSubqueriesandJoins
Summary
KeyTerms
ReviewQuestions
ProjectQuestions
MarciasDryCleaning
MorganImporting

PART2DATABASEDESIGN
Chapter3：TheEelationalModelandNormalization
ChapterObjectives
RelationalModelTerminology
Relations
CharacteristicsofRelations
AlternativeTerminology
FunctionalDependencies
FindingFunctionalDependencies
Keys
NormalForms
ModificationAnomalies
AShortHistoryofNormalForms
NormalizationCategories
FromFirstNormalFormtoBoyce-CoddNormalForm
EliminatingAnomaliesfromFunctionalDependencies
EliminatingAnomaliesfromMultivaluedDependencies
FifthNormalForm
Domain/KeyNormalForm
Summary
KeyTerms
ReviewQuestions
ProjectQuestions
MarciasDryCleaning
MorganImporting
Chapter4：DatabaseDesignUsingNormalization
ChapterObjectives
AssessTableStructure
DesigningUpdatableDatabases
AdvantagesandDisadvantagesofNormalization
FunctionalDependencies
Normalizingwith
ChoosingNottoUseBCNF
MultivaluedDependencies
DesigningRead-OnlyDatabases
Denormalization
CustomizedDuplicatedTables
CommonDesignProblems
TheMultivalue，MulticolumnProblem
InconsistentValues
MissingValues
TheGeneral-PurposeRemarksColumn
Summary
KeyTerms
ReviewQuestions
ProjectQuestions
MarciasDryCleaning
MorganImporting
Chapter5：DataModelingwiththeEntity-RelationshipModel
ChapterObjectives
ThePurposeofaDataModel
TheEntity-RelationshipModel
Entities
Attributes
Identifiers
Relationships
MaximumCardinality
MinimumCardinality
Entity-RelationshipDiagramsandTheirVersions
VariationsoftheE-RModel
E-RDiagramsUsingtheIECrowsFootModel
StrongEntitiesandWeakEntities
ID-DependentEntities
Non-ID-DependentWeakEntities
SubtypeEntities
PatternsinForms，Reports，andE-RModels
StrongEntityPatterns
ID-DependentRelationships
MixedIdentifyingandNonidentifyingPatterns
TheFor-Use-ByPattern
RecursivePatterns
TheDataModelingProcess
TheCollegeReport
TheDepartmentReport
TheDepartment/MajorReport
TheStudentAcceptanceLetter
Summary
KeyTerms
ReviewQuestions
ProjectQuestions
MarciasDryCleaning
MorganImporting
Chapter6：TransformingDataModelsintoDatabaseDesigns
ChapterObjectives
CreateaTableforEachEntity
SelectingthePrimaryKey
SpecifyingCandidate（Alternate）Keys
SpecifyColumnProperties
VerifyNormalization
CreateRelationships
RelationshipsBetweenStrongEntities
RelationshipsUsingID-DependentEntities
RelationshipswithaWeakNon-ID-DependentEntiy
RelationshipsinMixedEntityDesigns
RelationshipsBetweenSupertypeandSubtypeEntities
RecursiveRelationships
RepresentingTernaryandHigher-OrderRelationships
RelationalRepresentationoftheHighlineUniversityDataModel
DesignforMinimumCardinality
ActionsWhentheParentIsRequired
ActionsWhentheChildIsRequired
ImplementingActionsforM-ORelationships
ImplementingActionsforO-MRelationships
ImplementingActionsforM-MRelationships
DesigningSpecialCaseM-MRelationships
DocumentingtheMinimumCardinalityDesign
AnAdditionalComplication
SummaryofMinimumCardinalityDesign
TheViewRidgeGalleryDatabase
SummaryofRequirements
TheViewRidgeDataModel
DatabaseDesignwithDataKeys
MinimumCardinalityEnforcementforRequiredParents
MinimumCardinalityEnforcementfortheRequiredChild
ColumnPropertiesfortheViewRidgeDatabaseDesignTables
Summary
KeyTerms
ReviewQuestions
ProjectQuestions
MarciasDryCleaning
MorganImporting

PART3DATABASEIMPLEMENTATION
Chapter7：SQLforDatabaseConstructionandApplicationProcessing
ChapterObjectives
TheViewRidgeGalleryDatabase
SQLDDL，DML，andaNewTypeofJoin
……
PART4MULTIUSERDATABASEPROCESSING
PART5DATABASEACCESSSTANDARDS
APPENDICES
Bibliography
Glossary
Index