CHAPTER 7

STORING ORGANIZATIONAL INFORMATION - DATABASE

RELATIONAL DATABASE FUNDAMENTAL

ENTITIES AND ATTRIBUTES

KEYS AND RELATIONSHIPS

—Potential relational database for Coca-Cola

RELATIONAL DATABASE ADVANTAGES

1. INCREASED FLEXIBILITY

2. INCREASED SCALABILITY AND PERFORMANCE

3. REDUCED INFORMATION REDUNDANCY

4. INCREASED INFORMATION INTEGRITY (QUALITY)

5. INCREASED INFORMATION SECURITY

DATABASE MANAGEMENT SYSTEMS

DATA-DRIVEN WEB SITES

DATA-DRIVEN WEB SITES BUSINESS ADVANTAGES

DATA-DRIVEN BUSINESS INTELLIGENCE

—BI in a data-driven Web site

INTEGRATING INFORMATION AMONG MULTIPLE DATABASES

—Forward integration

—Backward integration

—Building a central repository specifically for integrated information