As long as Object Expressions like ‘a season ticket for performance 108’ occur only in this one Fact Type ‘Performance Price’, we have no advice to choose between the two ways of modeling shown in Figures 6.9 and 6.10. The information model might be slightly more complicated but might show an important Object Type, and there is no difference in the Relational database that can be derived from the models. However, if the same Object Expressions occur in sentences of more than one Fact Type, then there is no longer a free choice between these ways of modeling, and the extra Object Type must be modeled. The next section shows why.

Performance Price:“The price of a single ticket for performance 105 is $35.00.”“ “ “ “ “ season “ “ “ 105 “ “31.50.” ...

Get Fact Oriented Modeling with FCO-IM: Capturing Business Semantics in Data Models with Fully Communication Oriented Information Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.