FCO-IM English Book

(C) Copyright 2002 FCO-IM Consultancy

The list below shows the contents pages in text format. If you're interested, please follow the link at the bottom of this page to download your copy of the free PDF file.

Contents

1 Information Systems, Information Systems Development and Information Modeling 1

1.1 Information Systems 1
1.2 Information Systems Development and Information Modeling 2
1.3 Basic Principles of FCO-IM 11

2 Modeling the Communication 15

2.1 Starting Document 15
2.2 Concrete Examples 17
2.3 Verbalization 20
2.4 Classification and Qualification 24
2.5 Information Grammar Diagram (IGD) 34
2.6 Regenerating Fact Expressions from an IGD 46
2.7 Semantically Equivalent Models 49
2.8 Derivable Fact Types 53
2.9 Introducing New Identifiers 55
2.10 Subtle Substitution 58
2.11 Tuple Numbers and Tuple Pointers 62

3 Constraints 65

3.1 Value Constraints 67
3.2 Uniqueness Constraints 68
3.3 Test after Determining Uniqueness Constraints 78
3.4 Totality Constraints 91
3.5 Subset Constraints and Equality Constraints 97
3.6 Exclusion Constraints 100
3.7 Cardinality Constraints 101
3.8 Final Remarks 103

4 Derivation of a Relational Schema 105

4.1 Grouping 106
4.2 Lexicalizing 113
4.3 Reducing 120
4.4 Towards a Relational Schema 122
4.5 Generating DDL 129
4.6 Final Remarks 131

5 Various Modeling Issues 134

5.1 Semantically Equivalent Transformations 134
5.2 Unary Fact Types 154
5.3 Addresses with Postal Codes: Denormalization 157

6 Specialization and Generalization 170

6.1 Specialization 170
6.2 Generalization 190

7 Derivation of a Relational Schema with Specialization and Generalization 214

7.1 Derivation of a Relational Schema with Specialization 214
7.2 Derivation of a Relational Schema with generalization 229

Appendix A: Recommended Operational Procedure 245
Appendix B: FCO-IM and NIAM 246
Literature List 250

You may download the PDF file and a Free CaseTalk Book Edition here.