Tuesday, January 21, 2025

Revision 1 (6/25) of CONCEPTUAL MODELING FOR DATABASE DESIGN - A Sound Guide



 


Table of Contents

Introduction
1 Information Representation
2 Conceptual Modeling
2.1 Ontological Commitment
2. 2 Properties and Relationships
3. Entity Properties  
3.1 First Order Properties
3.2 Assertion Predicates
3.3 Second Order Properties
4 Group Properties
4.1 Third Order Properties
4.1.1 Entity Uniqueness
4.1.2 1OP (in Context) Dependencies
4.1.3 Aggregates Relationships
4.1.4 Meaning Criteria and ESS Relationships
4.1.5 Designation “Property”
5 Multigroup Fourth Order Properties
5.1 Inter-group Entity Relationships
5.2 Inter-group Aggregates Relationships
6. Business Rules
6.1 Entity Type Rules
6.2 Group Type Rules
6.3 Multigroup Type Rules
Conclusion
Appendix: PoM/OCP and RDM





Revision 1 (7/25) of RELATIONAL DATABASE DOMAINS: A Definitive Guide






Table of Contents

Introduction
1 Formal Theory and Interpretation
2 Database Domains
2.1 Domains As Data Types
2.1.1 RDM and Programming Data Types
2.1.2 Abstract Data Types
2.2 Domain Definition
2.2.1 Type Specification
2.2.2 Domain Operators
3 Kinds of Domains
3.1 Base and Derived Domains
3.2 Primitive Domains
3.3 Atomic ("Simple") Domains
3.4 Complex (Derived) Domains
4 RDM Type System
5 DBMS Domain Support
Appendix 1: A Complex Domain Example
Appendix 2: A Note on SQL Built-in Data Types


 

 

 

View My Stats