$1.(6$ points$)$ Assume that we have a product hierarchy based on the dimension of products: products belong to productlines and productlines belong to brands. Each dimension has a Name field with the brand also having a $3-$letter abbreviation field. Each brand has a percent markup, which establishes the final selling price $($e$.$g product cost x brand markup$).$ For each product, a final selling price is recorded in the fact table.

Draw the tables $($below$)$ for this hierarchy assuming they are snowflaked from a central fact table. $($Construct a snowflake schema and provide appropriate fields $-$ data not required$)$