Description
Book SynopsisToday all enterprises, from retail stores to financial institutions, manufacturing to government departments, depend on their databases to provide the crucial information essential to running their businesses. Databases are central for the rapidly growing and maturing electronic commerce.
Table of ContentsPreface xxv
PART I BASIC DATABASE CONCEPTS 1
1 THE DATABASE APPROACH 3
2 OVERVIEW OF MAJOR COMPONENTS 36
PART II DATABASE DEVELOPMENT PROCESS 67
3 SIGNIFICANCE OF THE DATABASE ENVIRONMENT 69
4 DATABASE DEVELOPMENT LIFE CYCLE 93
PART III CONCEPTUAL DATA MODELING 141
5 DATA MODELING BASICS 143
6 OBJECT-BASED DATA MODEL: PRINCIPLES AND COMPONENTS 167
7 ENTITY-RELATIONSHIP DATA MODEL 206
PART IV THE RELATIONAL DATA MODEL 237
8 RELATIONAL DATA MODEL FUNDAMENTALS 239
9 SEMANTIC DATA MODEL TO RELATIONAL DATA MODEL 273
10 DATA NORMALIZATION METHOD 303
PART V DESIGN AND IMPLEMENTATION 331
11 COMPLETING THE LOGICAL DESIGN 333
12 THE PHYSICAL DESIGN PROCESS 351
13 SPECIAL IMPLEMENTATION CONSIDERATIONS 385
PART VI DATABASE ADMINISTRATION AND MAINTENANCE 423
14 OVERVIEW OF ADMINISTRATION FUNCTIONS 425
15 DATA INTEGRITY 446
16 DATABASE SECURITY 495
17 ONGOING MAINTENANCE AND GROWTH 525
PART VII ADVANCED DATABASE TOPICS 551
18 DISTRIBUTED DATABASE SYSTEMS 553
19 DATABASE SYSTEMS AND THE WEB 598
20 TRENDS IN DATABASE TECHNOLOGY 636
APPENDICES 685
A Legacy System Models: Hierarchical and Network 687
B Codd's Relational Rules 692
C Diagramming Conventions and Symbols 694
D Use of CASE tools 700
E Review of major commercial DBMSs 703
F Database Design and Development Summary 712
References 716
Glossary 718
Index 729
