PART1Background
CHAPTER1IntroductiontoDatabases
1.1Introduction
1.2TraditionalFile-BasedSystems
1.2.1File-BasedApproach
1.2.2LimitationsoftheFile-BasedApproach
1.3DatabaseApproach
1.3.1TheDatabase
1.3.2TheDatabaseManagementSystem(DBMS)
1.3.3(Database)ApplicationPrograms
1.3.4ComponentsoftheDBMSEnvironment
1.3.5DatabaseDesign:TheParadigmShift
1.4RolesintheDatabaseEnvironment
1.4.1DataandDatabaseAdministrators
1.4.2DatabaseDesigners
1.4.3ApplicationDevelopers
1.4.4End-Users
1.5HistoryofDatabaseManagementSystems
1.6AdvantagesandDisadvantagesofDBMSs
ChapterSummary
ReviewQuestions
Exercises
CHAPTER2DatabaseEnvironment
2.1TheThree-LevelANSI-SPARCArchitecture
2.1.1ExternalLevel
2.1.2ConceptualLevel
2.1.3InternalLevel
2.1.4Schemas,Mappings,andInstances
2.1.5DataIndependence
2.2DatabaseLanguages
2.2.1TheDataDefinitionLanguage(DDL)
2.2.2TheDataManipulationLanguage(DML)
2.2.3Fourth-GenerationLanguages(4GLs)
2.3DataModelsandConceptualModeling
2.3.1Object-BasedDataModels
2.3.2Record-BasedDataModels
2.3.3PhysicalDataModels
2.3.4ConceptualModeling
2.4FunctionsofaDBMS
ChapterSummary
ReviewQuestions
Exercises
CHAPTER3DatabaseArchitecturesandtheWeb
3.1Multi-userDBMSArchitectures
3.1.1Teleprocessing
3.1.2File-ServerArchitecture
3.1.3TraditionalTwo-TierClient-ServerArchitecture
3.1.4Three-TierClient-ServerArchitecture
3.1.5N-TierArchitectures
3.1.6Middleware
3.1.7TransactionProcessingMonitors
3.2WebServicesandService-OrientedArchitectures
3.2.1WebServices
3.2.2Service-OrientedArchitectures(SOA)
3.3DistributedDBMSs
3.4DataWarehousing
3.5ComponentsofaDBMS
3.6OracleArchitecture
3.6.1Oracle誷LogicalDatabaseStructure
3.6.2Oracle誷PhysicalDatabaseStructure
ChapterSummary
ReviewQuestions
Exercises
PART2TheRelationalModelandLanguages
CHAPTER4TheRelationalModel
4.1BriefHistoryoftheRelationalModel
4.2Terminology
4.2.1RelationalDataStructure
4.2.2MathematicalRelations
4.2.3DatabaseRelations
4.2.4PropertiesofRelations
4.2.5RelationalKeys
4.2.6RepresentingRelationalDatabaseSchemas
4.3IntegrityConstraints
4.3.1Nulls
4.3.2EntityIntegrity
4.3.3ReferentialIntegrity
4.3.4GeneralConstraints
4.4Views
4.4.1Terminology
4.4.2PurposeofViews
4.4.3UpdatingViews
ChapterSummary
ReviewQuestions
Exercises
CHAPTER5RelationalAlgebraandRelationalCalculus
5.1TheRelationalAlgebra
5.1.1UnaryOperations
5.1.2SetOperations
5.1.3JoinOperations
5.1.4DivisionOperation
5.1.5AggregationandGroupingOperations
5.1.6SummaryoftheRelationalAlgebraOperations
5.2TheRelationalCalculus
5.2.1TupleRelationalCalculus
5.2.2DomainRelationalCalculus
5.3OtherLanguages
ChapterSummary
ReviewQuestions
Exercises
CHAPTER6SQL:DataManipulation
6.1IntroductiontoSQL
6.1.1ObjectivesofSQL
6.1.2HistoryofSQL
6.1.3ImportanceofSQL
6.1.4Terminology
6.2WritingSQLCommands
6.3DataManipulation
6.3.1SimpleQueries
6.3.2SortingResults(ORDERBYClause)
6.3.3UsingtheSQLAggregateFunctions
6.3.4GroupingResults(GROUPBYClause)
6.3.5Subqueries
6.3.6ANYandALL
6.3.7Multi-tableQueries
6.3.8EXISTSandNOTEXISTS
6.3.9CombiningResultTables(UNION,INTERSECT,EXCEPT)
6.3.10DatabaseUpdates
ChapterSummary
Review