PART 1 INTRODUCTION CHAPTER I INTRODUCTION TO DATABASE PROCESSING 1.1 Four Database Examples 1.2 The Relationship of Application Programs and the DBMS 1.3 File-Processing Systems 1.4 Database Processing Systems 1.5 Definition of a Database 1.6 The History of Database Processing 1.7 Summary 1.8 Group I Questions 1.9 Projects CHAPTER 2 INTRODUCTION TO DATABASE DEVELOPMENT 2.1 The Database 2.2 The DBMS 2.3 Creating the Database 2.4 Components of Applications 2.5 Database Development Processes 2.6 Summary 2.7 Group I Questions 2.8 Group II Questions PART 2 DATA MODELING CHAPTER 3 THE ENTITY-RELATIONSHIP MODEL 3.1 Elements of the Entity-Relationship Model 3.2 Examples 3.3 Databases as Models of Models 3.4 Summary 3.5 Group I Questions 3.6 Group II Questions 3.7 Projects CHAPTER 4 THE SEMANTIC OBJECT MODEL 4.1 Semantic Objects 4.2 Creating Data Models with Semantic Objects 4.3 Types of Objects 4.4 Comparing the Semantic Object and the E-R Model 4.5 Summary 4.6 Group I Questions 4.7 Group II Questions 4.8 Projects PART 3 DATABASE DESIGN CHAPTER 5 THE RELATIONAL MODELAND NORMALIZATION 5.1 The Relational Model 5.2 Normalization 5.3 First Through Fifth Normal Forms 5.4 Domain/Key Normal Form 5.5 The Synthesis of Relations 5.6 Multi-Value Dependencies, Iteration 2 5.7 Optimization 5.8 Summary 5.9 Group I Questions 5.10 Group II Questions CHAPTER 6 DATABASE DESIGN USING ENTITY-RELATIONSHIP MODELS 6.1 Transformation of Entity-Relationship Models into Relational Data Base Designs 6.2 Example Design 6.3 Trees, Networks, and Bills of Materials 6.4 Summary 6.5 Group I Questions 6.6 Group II Questions 6.7 Projects CHAPTER 7 DATABASE DESIGN WITH SEMANTIC OBJECT MODELS 7.1 Transformation of Semantic Objects into Relational Database Designs 7.2 Sample Objects 7.3 Summary 7.4 Group I Questions 7.5 Group II Questions 7.6 Projects PART 4 DATABASE IMPLEMENTATION WITH THE RELATIONAL MODEL CHAPTER 8 FOUNDATIONS OF RELATIONAL IMPLEMENTATION 8.1 Defining Relational Data 8.2 Relational Data Manipulation 8.3 Relational Algebra 8.4 Summary 8.5 Group I Question CHAPTER 9 STRUCTURED QUERY LANGUAGE 9.1 Querying a Single Table 9.2 Querying Multiple Tables 9.3 Exists and Not Exists 9.4 Changing Data 9.5 Summary 9.6 Group I Questions 9.7 Group Il Questions 9.8 Projects CHAPTER 10 DATABASE APPLICATION DESIGN 10.1 Functions of a Database Application 10.2 Case Application: View Ridge Gallery 10.3 Creating, Reading, Updating, and Deleting View Instances 10.4 Form Design 10.5 Report Design 10.6 Enforcing Constraints 10.7 Security and Control 10.8 Application Logic 10.9 Summary 10.10 Group I Questions 10.11 Group II Questions 10.12 Projects PART 5 USING INTERNET TECHNOLOGY CHAPTER 11 DATABASE APPLICATIONS USING INTERNET TECHNOLOGY 11.1 Network Environments 11.2 Three-Tier Archithcture 11.3 Languages Used for Intemet-Technology Applications 11.4 Markup Languages: DHTML and XML 11.5 The Role of Web Servers: IIS and ASP 11.6 Summary 11.7 Group I Questions 11.8 Group II Questions 11.9 Project CHAPTER 12 MANAGING MULTI-USER DATABASES 12.1 Concurrency Control 12.2 Database Recovery 12.3 Database Security 12.4 Database Administration 12.5 Summary 12.6 Group I Questions 12.7 Group II Questions 12.8 Project CHAPTER 13 ACCESSING THE DATABASE SERVER: ODBC, OLE DB, AND ADO 13.1 The Web Server Data Environment 13.2 Open Database Connectivity(ODBC) Standard 13.3 OLE DB 13.4 ADO (Active Data Objects) 13.5 Summary 13.6 Group I Questions 13.7 Group U Questions 13.8 Projects PART 6 ENTERPRISE DATABASES CHAPTER 14 SHARING ENTERPRISE DATA 14.1 Enterprise Database Processing Architectures 14.2 Downloading Data 14.3 On Line Analytic Processing(OLAP) 14.4 Data Warehouses 14.5 Data Administration 14.6 Summary 14.7 Group I Questions 14.8 Group II Questions CHAPTER 15 RELATIONAL IMPLEMENTATION WITH DB2 15.1 Case Study: KDK Appliances 15.2 DB2: The Product 15.3 Relational Implementation Using DB2 15.4 Summary 15.5 Group I Questions 15.6 Group II Questions CHAPTER 16 THE HIERARCHICALAND NETWORK DATA MODELS 16.1 Library Example 16.2 Data Language/I 16.3 The CODASYL DBTG Model 16.4 Summary 16.5 Group I Questions 16.6 Group II Questions PART 7 OBJECT-ORIENTED DATABASE PROCESSING CHAPTER 17 OBJECT-ORIENTED DATABASE PROCESSING 17.1 A Sketch of Object-Oriented Programming 17.2 OOP Example 17.3 Object Persistence 17.4 Comparing ODBMS and Traditional DBMS 17.50DBMS Standards 17.6 Summary 17.7 Group I Questions 17.8 Group II Questions APPENDIX A DATA STRUCTURES FOR DATABASE PROCESSING APPENDIX B USING SQL SERVER 7.0 APPENDIX C WORKING WITH CYBERPRISE DBAPP GLOSSARY BIBLIOGRAPLIY
鄂公網(wǎng)安備 42010302001612號(hào) 