Allowed ticket type names modeled as metadata(VC 2 in the model, and IC 2 on column ‘ticket type’

Image159771.jpg

Table Performance Price

performance numberNN

ticket typeNN

priceNN

105

single

35.00

105

season

31.50

108

single

27.50

108

season

24.00

F8: “The price of a <ticket type> ticket for performance<performance number> is $<price>.”

IC 2: Column Performance Price(ticket type)can only contain the values ‘single’ or ‘season’.

Figure 6.8 Allowed ticket types modeled as metadata

The same trade-offs can be seen in Figures 6.7 and 6.8 as in Figures 6.3 and 6.4. When modeled as data, the information ...

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.