Part 1 - Remaining Table Types

lecture lab details identify and label tables in the connection 5g warehouse and streaming erds that fit into one of the categories below bridge table (labeled as “ b ”) new lookup tables that exist due to bridge tables tables that will require denormalization (labeled as “ d ”) order is very important here! make sure you are following the steps in order as each step is dependent on the previous step 1 identify & label xdm individual profile tables identify all tables directly related to (one hop away from) the xdm individual profile tables that do not yet have a label mark them with a star " " looking at only the schema’s you just labeled with a star perform the following tasks add a label “b” for bridge table – a table is considered a bridge table when two or more tables are related to it with the many side of the relationship from both tables pointing to the bridge table add a label “d” for tables to denormalize – any entity that has a 1\ m or m 1 cardinality with the xdm individual profile labeled table and is not already marked remember bridge table rule #1 when encountering a bridge table directly related to either a “p” or “e” the m 1 relationship acts like a lookup otherwise follow the standard denormalization rules step 2 identify & label xdm experience event tables identify all tables directly related to (one hop away from) the experience event labeled tables that do not yet have a label mark them with a star looking at only the tables you just labeled with a star perform the following tasks add a label “b” for bridge tables – a table is considered a bridge table when two or more tables are related to it with the many side of the relationship pointing to the bridge table add a label “d” for tables to denormalize – any table that has a 1\ m or m 1 cardinality with the xdm experience event labeled table and is not already marked remember bridge table rule #1 when encountering a bridge table directly related to either a “p” or “e” the m 1 relationship acts like a lookup otherwise follow the standard de normalization rules step 3 identify & label lookup tables identify all tables related to (does not matter how many hops you make) any of the lookup labeled tables that do not yet have a label mark them with a star " " looking at only the tables you just labeled with a star perform the following tasks add a label “ b ” for bridge tables – a table is considered a bridge table when two or more tables are related to it with the many side of the relationship pointing to the bridge table add a label “ d ” for tables to de normalize – any table that has a 1\ m or m 1 cardinality with a lookup table or bridge table related to a lookup remember bridge table rule #1 when encountering a bridge table directly related to either a “p” or “e” the m 1 relationship acts like a lookup otherwise follow the standard denormalization rules (hint, hint) review