Designing Data Marts from XML and Relational Data Sources - Data Warehousing Design and Advanced Engineering Applications - page 76

Table 5. Descriptive attributes for the parameters of Table 4

Hierarchy parameters Descriptive attributes

RoomTypeID TypeDesc

RoomBandID BandDesc

RoomFaciliyID FacilityDesc

RoomID Price, Floor, AdditionalNotes

PaymentMethodID PaymentMethod

County ID CountyName

StateID StateName

CityID CityName

CustomerForenames
CustomerSurnames
CustomerHomePhone
CustomerWorkPhone
CustomerMobilePhone
CustomerEmail

CustomerID

SingerForenames
SingerSurnames

SingerID

ConcertID ConcertName

Figure 9. Candidate DM schema for the integrated schema