数据库处理/基础、设计与实现/英文

《数据库处理:基础、设计与实现(第11版)(英文版)》：提前介绍了SQL查询
使用“螺旋方法”进行数据库设计
为数据建模和数据库设计使用了一种通用的信息工程“鸦脚”E-R模型
详细探讨了实际规范技术中的特定范式
使用了最新的DBMS技术：MicrosoftAccess2007，MicrosoftSQL．Setver2008，OracleDatabase11g，MySQI5．1
基于广泛使用的Web开发技术，创建了Web数据库应用
简介了商务智能系统
探讨了数据仓库和联机分析处理数据库设计中使用的维数据库概念

《数据库处理:基础、设计与实现(第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
Marcia'sDryCleaning
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
Marcia'sDryCleaning
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
Marcia'sDryCleaning
MorganImporting
Chapter5:DataModelingwiththeEntity-RelationshipModel
ChapterObjectives
ThePurposeofaDataModel
TheEntity-RelationshipModel
Entities
Attributes
Identifiers
Relationships
MaximumCardinality
MinimumCardinality
Entity-RelationshipDiagramsandTheirVersions
VariationsoftheE-RModel
E-RDiagramsUsingtheIECrow'sFootModel
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
Marcia'sDryCleaning
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
Marcia'sDryCleaning
MorganImporting

PART3DATABASEIMPLEMENTATION
Chapter7:SQLforDatabaseConstructionandApplicationProcessing
ChapterObjectives
TheViewRidgeGalleryDatabase
SQLDDL,DML,andaNewTypeofJoin
……
PART4MULTIUSERDATABASEPROCESSING
PART5DATABASEACCESSSTANDARDS
APPENDICES
Bibliography
Glossary
Index