McGraw-Hill@Osborne - Database Management Systems 2md Edition

《McGraw-Hill@Osborne - Database Management Systems 2md Edition》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、CONTENTSPREFACExxiiPartIBASICS11INTRODUCTIONTODATABASESYSTEMS31.1Overview41.2AHistoricalPerspective51.3FileSystemsversusaDBMS71.4AdvantagesofaDBMS81.5DescribingandStoringDatainaDBMS91.5.1TheRelationalModel101.5.2LevelsofAbstractioninaDBMS111.5.3DataIndependence141.6QueriesinaDBMS151

2、.7TransactionManagement151.7.1ConcurrentExecutionofTransactions161.7.2IncompleteTransactionsandSystemCrashes171.7.3PointstoNote181.8StructureofaDBMS181.9PeopleWhoDealwithDatabases201.10PointstoReview212THEENTITY-RELATIONSHIPMODEL242.1OverviewofDatabaseDesign242.1.1BeyondtheERModel25

3、2.2Entities,Attributes,andEntitySets262.3RelationshipsandRelationshipSets272.4AdditionalFeaturesoftheERModel302.4.1KeyConstraints302.4.2ParticipationConstraints322.4.3WeakEntities332.4.4ClassHierarchies352.4.5Aggregation37viiviiiDatabaseManagementSystems2.5ConceptualDatabaseDesignWi

4、ththeERModel382.5.1EntityversusAttribute392.5.2EntityversusRelationship402.5.3BinaryversusTernaryRelationships*412.5.4AggregationversusTernaryRelationships*432.6ConceptualDesignforLargeEnterprises*442.7PointstoReview453THERELATIONALMODEL513.1IntroductiontotheRelationalModel523.1.1Cr

5、eatingandModifyingRelationsUsingSQL-92553.2IntegrityConstraintsoverRelations563.2.1KeyConstraints573.2.2ForeignKeyConstraints593.2.3GeneralConstraints613.3EnforcingIntegrityConstraints623.4QueryingRelationalData643.5LogicalDatabaseDesign:ERtoRelational663.5.1EntitySetstoTables673.5.

6、2RelationshipSets(withoutConstraints)toTables673.5.3TranslatingRelationshipSetswithKeyConstraints693.5.4TranslatingRelationshipSetswithParticipationConstraints713.5.5TranslatingWeakEntitySets733.5.6TranslatingClassHierarchies743.5.7TranslatingERDiagramswithAggregation753.5.8ERtoRela

7、tional:AdditionalExamples*763.6IntroductiontoViews783.6.1Views,DataIndependence,Security793.6.2UpdatesonViews793.7Destroying/AlteringTablesandViews823.8PointstoReview83PartIIRELATIONALQUERIES894RELATIONALALGEBRAANDCALCULUS914.1Preliminaries914.2RelationalAlgebra924.2.1SelectionandPr

8、ojection934.2.2SetO