Question

In a STAR schema to track the shipments for a distribution company, the following dimension
tables are found: (1) time, (2) customer ship-to, (3) ship-from, (4) product, (5) type of deal, and (6)
mode of shipment. Review these dimensions and list the possible attributes for each of the
dimension tables. Also, designate a primary key for each table

Answer 1

Answer:

STAR Schema Description We will discuss the STAR schema to track shipments for a distribution company. This schema has six dimensional are time, customer ship-to, ship-from, product, type of deal, and mode of shipment.The attribute of the first dimension table is Time key, Day, Month