ABSTRACT

This is a major revision of this paper and supersedes all previous versions.

There are few data management aspects that are as thoroughly misunderstood, confused and abused as business modeling and database design, particularly the concepts business model, data model and logical model. That's because database practitioners are not required to learn, know and understand the history and fundamentals of their field and they don't. They usually learn some programming language (often on their own), at best train in some DBMS (often by just using it) and perform their jobs in "cookbook mode".

The purpose of this paper is to introduce practitioners to data fundamentals and advance understanding of business modeling and database design. It offers a systematic framework that:

Ø Provides a sound foundation framework for evaluating and adopting/selecting data management technologies, products, and practices

Ø Exposes the advantages of employing it and the costly consequences of ignoring it

Ø Demonstrates its practical value by applying it to debunk industry practices

TABLE OF CONTENTS

· Introduction

· What Meaning Means

· Business Modeling

§Basic Concepts

§General Relationships

§Arbitrary Relationships

§Typing & Business Rules

§Graphical Representation

· Database Design

§ Formalizing the Informal

§ Predicates & Propositions

§ Relational Data Model

§ Logical Models

·Understanding Data Management

§ Truth & Correctness

§ Database & DBMS Defined

·A Foundation Framework

· Applying the Framework

· Conclusion

· References

USE OF MATERIAL POLICY

PRICING AND ORDERING

Counter by Digits