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