Beginning Relational Data Modeling

1. Front Matter

   Pages i-xxvii

   PDF

2. Understanding and Organizing Data: Past and Present

   Pages 1-25

3. Introducing Relational Theory

   Pages 27-56

4. Understanding Relational Modeling Terminology

   Pages 57-87

5. Understanding Data Modeling Methods: Graphical Syntax

   Pages 89-106

6. Introducing Object-Oriented Data Modeling

   Pages 107-129

7. Examining Levels of Analysis

   Pages 131-161

8. How Data Models Fit Into Projects

   Pages 163-190

9. Building a Conceptual Model

   Pages 191-237

10. Building a Logical Model

    Pages 239-301

11. Transforming a Logical Model into a Physical Model

    Pages 303-345

12. Designing a Physical Model Only

    Pages 347-376

13. Introducing Dimensional Data Modeling

    Pages 377-420

14. Reverse-Engineering a Data Model

    Pages 421-466

15. Communicating with the Model

    Pages 467-486

16. Improving Data Quality and Managing Documentation

    Pages 487-515

17. Introducing Metadata Modeling

    Pages 517-531

18. Exploring Data Modeling Working Practices

    Pages 533-562

19. Back Matter

    Pages 563-604

    PDF

Data storage design, and awareness of how data needs to be utilized within an organization, is of prime importance in ensuring that company data systems work efficiently. If you need to know how to capture the information needs of a business system in a relational database model, but don't know where to start, then this is the book for you.

Beginning Relational Data Modeling, Second Edition will lead you step-by-step through the process of developing an effective logical data model for your relational database. No previous data modeling experience is even required. The authors infuse the book with concise, straightforward wisdom to explain a usually complex, jargon-filled discipline. And examples are based on their extensive experience modeling for real business systems.

• Curlingstone
• data analysis
• data storage
• database
• design
• documentation
• modeling
• relational database

Sharon Allen has worked in the field of data analysis for 24 years: 10 as a business consumer of data and 14 as a data/database modeler/architect. She has had the opportunity to experience many diverse industries medical, aerospace, entertainment (Hollywood), manufacturing (toys, appliances, wet chemicals, metal part & assemblies), transportation, and food service and is currently working for American Honda Motors as a database architect. She plans to finish a master's degree in computer science and possibly teach at a local college.

Policies and ethics