Paper #1, revised and expanded, is available for purchase. Please follow the instructions on the PAPERS page to order.
The purpose of this paper is to
introduce practitioners to data fundamentals and advance their understanding via business modeling for database design.
It focuses particularly on and
distinguishes between the three types of model that are often confused: business
model, logical model and data model.
The paper will delve into each
one in detail, explain the basic modeling and design concepts, principles and
methodology of formalizing an informal business model via the relational
data model into a formal logical database model which can be computerized.
Introduction
Business Modeling
Basic Modeling Concepts
Business Rules
Property Rules
Class Rules
Attribute Rules
Distinctness Rules
Functional Dependency Rules
Referential Rules
Associative Entities
Optional Rules
Business ModelsDatabase Design
Formalizing the Informal
Predicates and Propositions
The Relational Data Model
Relational Structure
Relational Manipulation
Relational Integrity
External Predicates
Integrity Constraints and Internal Predicates
Logical ModelsUnderstanding Database Management
A Foundation Framework
Applying the Framework (Exercises)Appendix A: Integrity Constraints Formulation and Verification
References
No comments:
Post a Comment