Database Design and Development: An Essential Guide for IT Professionals

Preface 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