Iceberg Exercise

iceberg.xml

<schema format="0.99" date="2016-05-27" time="15:31:03">
    <metadata changingRange="datetime" encapsulation="dbo" identity="int" metadataPrefix="Metadata" metadataType="int" metadataUsage="false" changingSuffix="ChangedAt" identitySuffix="ID" positIdentity="int" positGenerator="true" positingRange="datetime" positingSuffix="PositedAt" positorRange="tinyint" positorSuffix="Positor" reliabilityRange="decimal(5,2)" reliabilitySuffix="Reliability" deleteReliability="0" assertionSuffix="Assertion" partitioning="true" entityIntegrity="true" restatability="false" idempotency="true" assertiveness="false" naming="improved" positSuffix="Posit" annexSuffix="Annex" chronon="datetime2(7)" now="sysdatetime()" dummySuffix="Dummy" versionSuffix="Version" statementTypeSuffix="StatementType" checksumSuffix="Checksum" businessViews="true" decisiveness="true" equivalence="false" equivalentSuffix="EQ" equivalentRange="tinyint" databaseTarget="SQLServer" temporalization="crt"/>
    <knot mnemonic="SOM" descriptor="SplitOrMerge" identity="tinyint" dataRange="varchar(42)">
        <metadata capsule="dbo" generator="false"/>
        <layout x="367.24" y="434.72" fixed="false"/>
    </knot>
    <knot mnemonic="SUB" descriptor="Submerged" identity="tinyint" dataRange="varchar(42)">
        <metadata capsule="dbo" generator="false"/>
        <layout x="474.08" y="148.79" fixed="false"/>
    </knot>
    <knot mnemonic="FRZ" descriptor="Frozen" identity="tinyint" dataRange="varchar(42)">
        <metadata capsule="dbo" generator="false"/>
        <layout x="651.45" y="214.08" fixed="false"/>
    </knot>
    <knot mnemonic="EOE" descriptor="EnteringOrExiting" identity="tinyint" dataRange="varchar(42)">
        <metadata capsule="dbo" generator="false"/>
        <layout x="615.71" y="461.83" fixed="true"/>
    </knot>
    <anchor mnemonic="AE" descriptor="Area" identity="int">
        <metadata capsule="dbo" generator="true"/>
        <attribute mnemonic="NAM" descriptor="Name" identity="int" dataRange="varchar(123)">
            <metadata capsule="dbo" generator="true" assertive="false"/>
            <layout x="519.49" y="606.14" fixed="false"/>
        </attribute>
        <layout x="526.99" y="528.91" fixed="false"/>
    </anchor>
    <anchor mnemonic="IB" descriptor="Iceberg" identity="int">
        <metadata capsule="dbo" generator="true"/>
        <attribute mnemonic="FDA" descriptor="FormationDate" identity="int" dataRange="datetime">
            <metadata capsule="dbo" generator="true" assertive="false"/>
            <layout x="574.71" y="389.83" fixed="true"/>
        </attribute>
        <attribute mnemonic="FRZ" descriptor="Frozen" identity="int" timeRange="datetime" knotRange="FRZ">
            <metadata capsule="dbo" generator="true" assertive="false" restatable="false" idempotent="true"/>
            <layout x="586.33" y="256.43" fixed="true"/>
        </attribute>
        <attribute mnemonic="LOC" descriptor="Location" identity="int" timeRange="datetime" dataRange="geography">
            <metadata capsule="dbo" generator="true" assertive="true" checksum="true" restatable="false" idempotent="true"/>
            <layout x="503.05" y="232.71" fixed="false"/>
        </attribute>
        <attribute mnemonic="SUB" descriptor="Submerged" identity="int" timeRange="datetime" knotRange="SUB">
            <metadata capsule="dbo" generator="true" assertive="false" restatable="false" idempotent="true"/>
            <layout x="460.25" y="229.94" fixed="false"/>
        </attribute>
        <attribute mnemonic="SIZ" descriptor="Size" identity="int" timeRange="datetime" dataRange="int">
            <metadata capsule="dbo" generator="true" assertive="false" restatable="false" idempotent="true"/>
            <layout x="623.71" y="314.57" fixed="true"/>
        </attribute>
        <attribute mnemonic="DDA" descriptor="DisintegrationDate" identity="int" dataRange="datetime">
            <metadata capsule="dbo" generator="true" assertive="false"/>
            <layout x="562.93" y="356.31" fixed="false"/>
        </attribute>
        <layout x="494.36" y="340.10" fixed="false"/>
    </anchor>
    <tie identity="int">
        <anchorRole role="one" type="IB" identifier="false"/>
        <anchorRole role="many" type="IB" identifier="true"/>
        <knotRole role="as" type="SOM" identifier="false"/>
        <metadata capsule="dbo" generator="true" assertive="true"/>
        <layout x="422.35" y="392.97" fixed="true"/>
    </tie>
    <tie identity="int" timeRange="datetime">
        <anchorRole role="intersects" type="IB" identifier="true"/>
        <anchorRole role="the" type="AE" identifier="true"/>
        <knotRole role="by" type="EOE" identifier="false"/>
        <metadata capsule="dbo" generator="true" assertive="true" restatable="false" idempotent="true"/>
        <layout x="525.71" y="467.33" fixed="true"/>
    </tie>
</schema>