convert existing relational model to dimensional

Hi,

I have a logical model that is relational and propagate/cascade the keys from one table to next and so on. 

There are relationships in the model with 7-10 compounded keys because of this propagation.

I would like to use one column to be the key, such as a "surrogate key", foreign key to the next entity and the subsequent entity would not get propagated with compounded key.

what are the steps I need to convert this relational model to dimensional?

i.e.

Relational model

Entity1(Entity1_PK, attribute1, attr2, ... attrN)

Entity2(Entity2_PK, Entity1_PK, attributes...)

Entity3 ( Entity3_PK, Entity2_PK, Entity1_PK, attributes)   <- compounded keys

PK stands for primary key column.

Desire dimensional outcome:

Entity1(Entity1_PK, attribute1, attr2, ... attrN)

Entity2(Entity2_PK, Entity1_FK, attributes...)

Entity3 ( Entity3_PK, Entity2_FK, attributes)   <- compounded keys

FK stands for foreign key column.

Parents
  • Hello. I think these steps will be helpful:

    • Create table for a relationship.
    • Add the primary keys of all participating Entities as fields of table with their respective data types.
    • If relationship has any attribute, add each attribute as field of table.
    • Declare a primary key composing all the primary keys of participating entities.
      cupcake 2048
Reply
  • Hello. I think these steps will be helpful:

    • Create table for a relationship.
    • Add the primary keys of all participating Entities as fields of table with their respective data types.
    • If relationship has any attribute, add each attribute as field of table.
    • Declare a primary key composing all the primary keys of participating entities.
      cupcake 2048
Children
No Data