NEW SERIES HERE:
[ Ссылка ]
The 22nd video in a series about creating a Master Data Management system in SQL.
In this video, I show and explain the Domain and Shared Attribute shapes, along with some examples and commentary from Steve.
Synopsis:
The Domain Shape is an enhanced CFT-B shape used to model what the business needs. The Group Domain not only contains companies/clients but is also used to Template data and holds Tenants (multi-tenancy). The Tenant Id is not meant for a Parent-child relationship, the Relationship shape will take care of that.
A Shared Attribute is like an RCFT-R shape, except the R becomes an X. The X is a table similar to the Base in CFT-B, but it is actually a junction/bridge/relationship table between a Domain and the Shared Attribute in question.
These two shapes compliment and depend on each other.
The Domain Group consists of tblRefGroupClass, tblRefGroupFamily, tblRefGroupType, and tblGrpGroup. Imagine another Domain, tblRefPeopleClass, tblRefPeopleFamily, tblRefPeopleType, and tblPeoPeople. If we had the Shared Attribute Name (tblRefNameRealm, tblRefNameClass, tblRefNameFamily, tblRefNameType) then part of both the Domain and Shared Attribute shape would be two additional tables. tblGrpGroupName and tblPeoPeopleName.
If we added another Shared Attribute (IdNumber) then there would be the IdNumber RCFT tables plus a tblGrpGroupIdNumber, and a tblPeoPeopleIdNumber.
This shape can assist us in some seriously abstract modeling, including Pablo Picasso's full name.
This video uses heavily uses, DevArt’s SQL Complete. [ Ссылка ]
