Exercise 6
It's a foreign key.
It relates to the primary key of the table DimGeography.
Add DimCustomer as a source table for the City ID and add the Customer attribute as a child of City (one-to-many).
It's a foreign key.
It relates to the primary key of the table DimGeography.
Add DimCustomer as a source table for the City ID and add the Customer attribute as a child of City (one-to-many).